On Mon, 7/17/17, Saleem Ansari wrote:
Subject: Re: $$Excel-Macros$$ Urgent Help required
To: excel-macros@googlegroups.com
Date: Monday, July 17, 2017, 9:29 AM
Question not clear
On Mon, Jul 17, 2017 at
9:13 AM, Rakesh kumar
wrote:
Hi
see this attachment. hope it makes you understand.
On Mon, Jul 17, 2017 at 11:59 AM, Saleem Ansari
wrote:
> Question not clear
>
> On Mon, Jul 17, 2017 at 9:13 AM, Rakesh kumar
> wrote:
>
>> Hi Friends,
>>
>> I need urgent help, If any one can help me.
>>
>> actually I have got one assignment,
Question not clear
On Mon, Jul 17, 2017 at 9:13 AM, Rakesh kumar
wrote:
> Hi Friends,
>
> I need urgent help, If any one can help me.
>
> actually I have got one assignment, I need to solve it, but I'm completely
> stuck into this.
>
> Please see the attachment and help.
>
>
> --
> Thanks £ Rega
Hi Friends,
I need urgent help, If any one can help me.
actually I have got one assignment, I need to solve it, but I'm completely
stuck into this.
Please see the attachment and help.
--
Thanks £ Regards
Rakesh Kumar
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It
Can you share the file?There's really no other way I can even GUESS what might
be wrong.
Is the macro looking in the correct cell for a path?Is there a value in the
cell?Is the path spelled correctly? using the correct syntax?does the path
exist?
Since it works for ME, there's really no way to g
Dear Paul,
thanks for the reply.
I am also working on the option number 3, which you have suggested.
where is you see, I am assigning a value of path to a veriable "P" and the
using "ChDir = P"
where value of P is taking from a excel cell.
Kindly suggest what may be going wrong in it.
On Thu,
In Macro1, you specify the full pathname:Workbooks.Open Filename:= _
"D:\Phillipins\Automation\Raw Data\CUSTOMIZED REPORT.xlsx"
in the others, you are not defining the path.In the first you ARE using:ChDir
"D:\Phillipins\Automation\Raw Data"but don't need it in Macro1
since you're not incl
Dear Expert,
I am stuck in one very simple macro, and not able to find what's the
problem is.
Please help me with it as my entire work got stuck because of it.
I have three macros for same task, where first 1 is working perfectly and
opening the workbook "CUSTOMIZED REPORT.xlsx", But rest 2 are
e places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
From: Soumyendu Paul
To: excel-macros@googlegroups.com
Sent: Wednesday, August 26, 2015 1:24 AM
Subject: $$Excel-Macros$$ Urgent Help Required
Hi,
Want to searc
Hi,
Want to search header "Name" in attached file through vba but unable to do
with find method. Please help
Regards,
Soumyendu
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.co
Hi,
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help
Hi guys.
I have a sheet where I have couple of pivot tables.. So I want a macro,
where I can get access of entire sheet except pivot table data.. Pivot
table data should be locked and if i create another pivot table in the same
sheet. it should also be locked next time. So i can only use rest of t
Hi All,
i am working IE automation with one of the citrix page. when i nevigate
through page and click on close claim buttion i got one message.. do you
want to close the claim.
However i written one API which find the message and find the OK button and
click on OK. but issue to click on OK i
Hi Rakesh
Did you checked this?
+
*I did not do this for you. God is here working through me for you.*
On Tue, Dec 16, 2014 at 10:32 PM, Vaibhav Joshi wrote:
>
> Mr. Aptech...
>
>
> Check this..
>
> Goto Input sheet, Pres Alt + F8 to run macro..
>
> Cheers!!
>
> +
> *I did not do this f
Mr. Aptech...
Check this..
Goto Input sheet, Pres Alt + F8 to run macro..
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Tue, Dec 16, 2014 at 5:54 PM, Rakesh kumar
wrote:
>
> I want all, whatever the is available on sheets.
>
> On Tue, Dec 16, 2014 at
I want all, whatever the is available on sheets.
On Tue, Dec 16, 2014 at 5:47 PM, Vaibhav Joshi wrote:
>
> ok, do you want both or unique one?
>
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Tue, Dec 16, 2014 at 5:43 PM, Rakesh kumar
> wrote:
>>
>> it was
ok, do you want both or unique one?
+
*I did not do this for you. God is here working through me for you.*
On Tue, Dec 16, 2014 at 5:43 PM, Rakesh kumar
wrote:
>
> it was just sample output.
>
> On Tue, Dec 16, 2014 at 5:19 PM, Vaibhav Joshi wrote:
>>
>> there is 2 raw of data but your outp
it was just sample output.
On Tue, Dec 16, 2014 at 5:19 PM, Vaibhav Joshi wrote:
>
> there is 2 raw of data but your output doesn't contain 68 & what about
> repeated number 65 to 67?
>
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Tue, Dec 16, 2014 at 5:03
there is 2 raw of data but your output doesn't contain 68 & what about
repeated number 65 to 67?
+
*I did not do this for you. God is here working through me for you.*
On Tue, Dec 16, 2014 at 5:03 PM, Rakesh kumar
wrote:
>
> HI frinds,
> i want split cells value in diffrent row using macro
HI frinds,
i want split cells value in diffrent row using macros, please see the
attechment.
Please do it urgent basis if any one can.
--
Thanks £ Regards
Rakesh Kumar
+91-9650303464 <#>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join
column no action work.
>>>>
>>>> thanx
>>>>
>>>> On 30 September 2014 23:37, Vaibhav Joshi wrote:
>>>>>
>>>>> Sudhir
>>>>>
>>>>> Did you checked this
>>>>>
>>>>&
and
>>> secondly if there is need to increase column no action work.
>>>
>>> thanx
>>>
>>> On 30 September 2014 23:37, Vaibhav Joshi wrote:
>>>
>>>> Sudhir
>>>>
>>>> Did you checked this
>>>> ---
id you checked this
>>> -- Forwarded message --
>>> From: "Vaibhav Joshi"
>>> Date: Sep 27, 2014 2:38 PM
>>> Subject: Re: $$Excel-Macros$$ URGENT HELP( CONDITION SEARCH OF UNIQUE
>>> TEXT)
>>> To: "excel-macros@goo
is need to increase column no action work.
>
> thanx
>
> On 30 September 2014 23:37, Vaibhav Joshi wrote:
>
>> Sudhir
>>
>> Did you checked this
>> -- Forwarded message --
>> From: "Vaibhav Joshi"
>> Date: Sep 27, 2014 2:
ibhav Joshi"
> Date: Sep 27, 2014 2:38 PM
> Subject: Re: $$Excel-Macros$$ URGENT HELP( CONDITION SEARCH OF UNIQUE TEXT)
> To: "excel-macros@googlegroups.com"
> Cc:
>
> Hi
>
> Check this.. click blue button to run macro!
>
> Cheers!!
>
> +
> *
Sudhir
Did you checked this
-- Forwarded message --
From: "Vaibhav Joshi"
Date: Sep 27, 2014 2:38 PM
Subject: Re: $$Excel-Macros$$ URGENT HELP( CONDITION SEARCH OF UNIQUE TEXT)
To: "excel-macros@googlegroups.com"
Cc:
Hi
Check this.. click blue button t
Dear All,
Kindly help.
On 27 September 2014 14:38, Vaibhav Joshi wrote:
> Hi
>
> Check this.. click blue button to run macro!
>
> Cheers!!
>
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Thu, Sep 25, 2014 at 10:44 PM, SUDHIR VERMA
> wrote:
>
>> Dear Expe
Does that mean you would like to have color from 09th October till 23rd
Oct. in this case.
On Sun, Sep 28, 2014 at 12:20 PM, Rakesh kumar
wrote:
> hi friends,
>
> i need urgent help of yours
>
> in attached sheets column DOC has date. in next column 'No. of Days Req'
>
> if we enter 8 oct in
Hi
Check this.. click blue button to run macro!
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Thu, Sep 25, 2014 at 10:44 PM, SUDHIR VERMA wrote:
> Dear Experts,
>
> Kindly resolve my problem.
>
> Explanation in attached workbook.
>
> Thanking You
>
> R
Dear Ganesh,
Thanx for provide formula. It's also great but there is more than 100
column where were conditions found. So it is not possible to entered
formula.
thanking you
On 26 September 2014 09:44, Ganesh N wrote:
> Hi sudhir,
>
> PFA.
>
> Just given if condition.
>
> Regards,
> Ganesh N
Hi sudhir,
PFA.
Just given if condition.
Regards,
Ganesh N
On Thu, Sep 25, 2014 at 10:44 PM, SUDHIR VERMA wrote:
> Dear Experts,
>
> Kindly resolve my problem.
>
> Explanation in attached workbook.
>
> Thanking You
>
> Regards
> Sudhir
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?
Dear Experts,
Kindly resolve my problem.
Explanation in attached workbook.
Thanking You
Regards
Sudhir
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM
can you highlight error cells!!
On Mon, Jul 28, 2014 at 10:43 AM, bhanu prakash wrote:
> Hi Vaibhav,
>
> Had checked your solution, few lvl's are picking up correct & other few
> are lvl picking wrong #'s ..had checked your response..
>
> Regards,
> Bhanu
>
>
>
> On Sat, Jul 26, 2014 at 10:54 A
gt;
>>>
>>>
>>>
>>> *“Do all the good you can,By all the means you can,In all the ways you
>>> can,In all the places you can,At all the times you can, To all the people
>>> you can,As long as ever you can.” - John Wesley*
>>> ---
Hi Vaibhav,
Had checked your solution, few lvl's are picking up correct & other few are
lvl picking wrong #'s ..had checked your response..
Regards,
Bhanu
On Sat, Jul 26, 2014 at 10:54 AM, Vaibhav Joshi wrote:
> did this helped?
>
>
>
> On Fri, Jul 25, 2014 at 6:44 PM, Vaibhav Joshi wrote:
macros@googlegroups.com
> *Sent:* Friday, July 25, 2014 7:45 AM
> *Subject:* Re: $$Excel-Macros$$ URGENT : Help on excel for matching data
>
> Hi Paul,
>
> Thanks for your response.
>
> But here biggest challenge is FBC Value in DATA MATCH sheet ( Column E )
> is not e
did this helped?
On Fri, Jul 25, 2014 at 6:44 PM, Vaibhav Joshi wrote:
> Hi
>
> Pl refer attachment, due to your data formula became complex, you can
> check example next to it for an explanation.
>
> Cheers!!
>
>
> On Fri, Jul 25, 2014 at 3:45 PM, bhanu prakash wrote:
>
>> Team,
>>
>> Any ex
As long as ever you can.” - John Wesley
-
>
> From: bhanu prakash
>To: excel-macros@googlegroups.com
>Sent: Friday, July 25, 2014 7:45 AM
>Subject: Re: $$Excel-Macros$$ URGENT : Help on excel for match
> you can,As long as ever you can.” - John Wesley*
> -
>
>*From:* bhanu prakash
> *To:* excel-macros@googlegroups.com; bhanu.prakas...@oracle.com
> *Sent:* Friday, July 25, 2014 2:11 AM
> *Subject:* $$Excel-Macros$$ URGENT : Help on exce
;Sent: Friday, July 25, 2014 2:11 AM
>Subject: $$Excel-Macros$$ URGENT : Help on excel for matching data
>
>
>
>Hello Team,
>
>Hope everyone doing good.
>
>Had attached the excel sheet for reference
>
>in that Excel you will find 2 tabs - one is "SOURCE" an
Team,
Any experts for help on below mentioned request..please help
Regards, Bhanu
On Fri, Jul 25, 2014 at 11:41 AM, bhanu prakash wrote:
> Hello Team,
>
> Hope everyone doing good.
>
> Had attached the excel sheet for reference
>
> in that Excel you will find 2 tabs - one is "SOURCE" and othe
Hi Excel Gurus,
I need your help as I am really stuck over here. I have data starting from
Nov 2012 till March 2014. I have created various charts for my dashboard
and have also inserted a timeline slicer to my pivots. The orientation of
this dashboard is portrait and the timeline is given on t
Hey
You can increase line spacing..
Sub para()
Dim oPara As Paragraph
For Each oPara In ActiveDocument.Paragraphs
If Not (Len(oPara.Range.Text) <> 1 And Not
oPara.Range.ListFormat.ListType = bulletList) Then
With oPara
.SpaceAfter = 0
Hi Davidson,
PFA..!!!
If, its not meet your requirement then elaborate more.
Regards
Ashish
On 18 June 2014 19:25, Davidson Chew wrote:
> Hi everyone, I need some real urgent help with my VBA Macro for Microsoft
> Word.
>
> Here's my current code:
> Dim oPara As Paragraph
> F
Hi everyone, I need some real urgent help with my VBA Macro for Microsoft
Word.
Here's my current code:
Dim oPara As Paragraph
For Each oPara In ActiveDocument.Paragraphs
If Not (Len(oPara.Range.Text) <> 1 And Not oPara.Range.ListFormat.
ListType = bulletList) Then
oPa
My code is -
Sub SavePDF()
' pdf Macro
Application.ScreenUpdating = False
Sheets("Invoice").Select
Range("A1:A52").Select
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, FileName:= _
"G:\SAMAYENT\Invoice\" & Range("A9").Value & " Order No# " &
Range("F9").Value & " Invoice
attachment missing !
On Sat, Oct 5, 2013 at 11:22 AM, Rakesh kumar wrote:
>
> Dear Friend,
>
> i want to use total no of present or absent list using pivot table.
>
> Please find the attachment.
>
>
> --
> Thanks £ Regards
> Rakesh Kumar
> +91-9650303464
>
>
>
> --
> Are you =EXP(E:RT) or =NOT(E
Dear Friend,
i want to use total no of present or absent list using pivot table.
Please find the attachment.
--
Thanks £ Regards
Rakesh Kumar
+91-9650303464
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this
Dear De Premor & Ravinder Sir,
Thanks for your help and valuable support. Thanks a lot.
Thanks,
Ashish Kumar
On Saturday, September 7, 2013 11:32:20 AM UTC+5:30, De Premor wrote:
>
> The good thing is that your sheet name have a same name with what we are
> looking for also the name of month,
The good thing is that your sheet name have a same name with what we are
looking for also the name of month, so we can process it easily, try
this on B2
=COUNTA(OFFSET(INDIRECT($A2&"!$A1"
),2,MATCH(B$1,INDIRECT($A2&"!$1:$1"),0)-1,2^16))
On 07-09-2013 12:43, Ashish Kumar wrote:
Dear Seniors,
Dear Senior,
All data in single workbook in different sheets and i want to create a
summary in output sheet. Data pattern will be same according to the sheet
which i'hve attached for query reference.
Thanks,
Ashish
On Saturday, September 7, 2013 11:22:03 AM UTC+5:30, Excel Group wrote:
>
> Hi
Hi Ashish,
Please confirm that the all data in a single sheet or in different
different sheets.
On Sat, Sep 7, 2013 at 11:13 AM, Ashish Kumar wrote:
> Dear Seniors,
>
>
> I want total count of Sold Items according to the state or months. I'hve
> tried this through Counta formula but this is h
Dear Seniors,
I want total count of Sold Items according to the state or months. I'hve
tried this through Counta formula but this is huge volume of data, so
please suggest me the easy way.
Thanks,
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,D
l find here with sales register
> kindly help me to sort out and also inform how i could make such file like
> also same in the case of
> purchase register
> thanks
> d v nayak
>
> --
> Date: Tue, 23 Jul 2013 17:06:24 +0530
> Subject: Re: $$
Hi nayak..pls share the file..
On Jul 23, 2013 12:02 PM, "devanand nayak" wrote:
> hi
> i have one sheet which consists of data on daily basis for whole year
> e.g. datecustomer name tin no net 12.5% vat 12.5% net 5%
> vat 5% oms tranpsort total
>
> i need this with tinwise t
hi
i have one sheet which consists of data on daily basis for whole year
e.g. datecustomer name tin no net 12.5% vat 12.5% net 5% vat
5% oms tranpsort total
i need this with tinwise total for whole year and whole year net total and
whole year vat total
any one can help me
Hi all experts,
Atlast i found the resolution for this issue. i have checked with the team
who are sending this file in zip format on a daily bases. the root cause of
this problem is while zipping this file they get some error. they simply
ignored it and sending this file. when i check with the fi
Respected Prabhu,
Verify that the other cells linked to it are not hidden.Remove any
formulas or links(hyper links or other links) that the cell contains with
other sheets.Also verify that whether multiple cell which are hidden around
the cell are not selected when you select the cell.If the ce
Pl share your file with group.
And use the appropriate subject for your query.
On Tue, May 28, 2013 at 6:44 PM, Prabhu Pinky wrote:
> Nope I have selected only one cell in only one sheet.
>
> Prabhu R
> On May 28, 2013 3:50 PM, "David Grugeon" wrote:
>
>> Perhaps you have more than one sheet sel
Nope I have selected only one cell in only one sheet.
Prabhu R
On May 28, 2013 3:50 PM, "David Grugeon" wrote:
> Perhaps you have more than one sheet selected.
>
> Regards
> David Grugeon
>
>
>
> On 28 May 2013 14:37, Prabhu Pinky wrote:
>
>> hi experts
>>
>> I have one excel, from that excel I
Perhaps you have more than one sheet selected.
Regards
David Grugeon
On 28 May 2013 14:37, Prabhu Pinky wrote:
> hi experts
>
> I have one excel, from that excel I am unable to copy and paste the data
> to new excel..even a single cell..am getting "this command is cannot be
> processd in mult
http://social.technet.microsoft.com/Forums/en-US/officeitpro/thread/cfbcd96c-bcf1-48dc-940e-5d859f44e217
On Tue, May 28, 2013 at 11:26 AM, Prabhu Pinky wrote:
> Hi..
> Am unable to attach the sheet, since there is violation in our office.
>
> As I said earlier, I have selected only one cell. So
Hi..
Am unable to attach the sheet, since there is violation in our office.
As I said earlier, I have selected only one cell. So there is no matter if
I use filter.
Prabhu R
On May 28, 2013 10:42 AM, "VBA VABZ" wrote:
> Hi
>
> Either source sheet has filter or merged cells. Try clearing out f
Dear Prabhu,
Are u pressing cltr+then selecting the cells and trying to copy the
things.?
if u selecting the cells vertically or horizontally but in straight line
then it should copy by selecting cltr key.
But if u selecting the cells randomly then it will not copy and throws the
message whic
Hi
Either source sheet has filter or merged cells. Try clearing out filter
and perform operation again.
If doesn't work send us sheet.
HTH
On 28 May 2013 10:07, "Prabhu Pinky" wrote:
> hi experts
>
> I have one excel, from that excel I am unable to copy and paste the data
> to new excel..even
hi experts
I have one excel, from that excel I am unable to copy and paste the data to
new excel..even a single cell..am getting "this command is cannot be
processd in multiple selection" error message..
But am sure I selected and copied only single, but donno how am getting
thus errorpls hel
: $$Excel-Macros$$ Urgent help required for Vlookup macro code
Hi Experts,
I have data with Employee number,based on employee number i need to
get the date of join.i have many file with DOJ.
What is the VBA vlookup code for looking one file and if not find the
DOJ filter blanks and asking next
Dear Nagendra,
Please use it
Sub USINGVLOOKUP()
Dim X As Range
Set X = Sheets(1).Range("$A$1:$D$9")
Range("E15").Value
=Application.Worksheetfunction.VLookup(Sheets(1).Range("B15").Value, X, 4,
False)
End Sub
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.bl
just share your data.
Gawli Anil
On Tue, Jun 5, 2012 at 10:00 AM, Nagendra Modupalli wrote:
> Hi Experts,
>
> I have data with Employee number,based on employee number i need to
> get the date of join.i have many file with DOJ.
>
> What is the VBA vlookup code for looking one file and if not find
Hi Experts,
I have data with Employee number,based on employee number i need to
get the date of join.i have many file with DOJ.
What is the VBA vlookup code for looking one file and if not find the
DOJ filter blanks and asking next file to lookup. Thanks in advance.
--
Thanks&Regards
Nagendra.
Hi,
Function English(ByVal N As Currency) As String
Const Thousand = 1000@
Const Million = Thousand * Thousand
Const Billion = Thousand * Million
Const Trillion = Thousand * Billion
If (N = 0@) Then English = "zero": Exit Function
Dim Buf As String: If (N < 0@
s.com
Subject: $$Excel-Macros$$ urgent help-ActiveX
Hi Expert,
I am using TextBox and Listbox and multiple sheet. but when ever macros
under this control run, control size being reduce.
Kindly tell me whats reason may be.
Divaker Pandey
--
FORUM RULES (986+ members already BANNE
not return an error if the number
is not found, so we need to verify that it found the correct number.
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Satvik
Sent: Friday, March 02, 2012 5:49 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macro
: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Urgent Help Required...!
u can try this one
=INDEX('E:\Desktop\[NDNC
file.xlsx]Sheet1'!$A$2:$B$11,MATCH(A2,'E:\Desktop\[NDNC
file.xlsx]Sheet1'!$A$2:$A$11,0),2)
On Sat, Mar 3, 2012 at 7:19 AM, Satvik wrote:
> **
*To: *
> *ReplyTo: *excel-macros@googlegroups.com
> *Subject: *Re: $$Excel-Macros$$ Urgent Help Required...!
>
> Hi,
> You can use vlookup to find the callable # from DNC sheet. Find the
> attached file for ur reference.
>
> On Sat, Mar 3, 2012 at 6:59 AM, Satvik wrote:
43:19
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Urgent Help Required...!
Hi,
You can use vlookup to find the callable # from DNC sheet. Find the
attached file for ur reference.
On Sat, Mar 3, 2012 at 6:59 AM, Satvik wrote:
> **
> Thanks for the replay Shaik
erry® on Airtel
> --
> *From: *Shaik Waheed
> *Sender: *excel-macros@googlegroups.com
> *Date: *Fri, 2 Mar 2012 18:11:44 +0530
> *To: *
> *ReplyTo: *excel-macros@googlegroups.com
> *Subject: *Re: $$Excel-Macros$$ Urgent Help Required...!
>
> Hi,
>
> Do you want to chek wh
Thanks for the replay Shaik...
Yes I need to check with DNC..
Sent from BlackBerry® on Airtel
-Original Message-
From: Shaik Waheed
Sender: excel-macros@googlegroups.com
Date: Fri, 2 Mar 2012 18:11:44
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Urgent
chk attachments solved
On Fri, Mar 2, 2012 at 6:11 PM, Shaik Waheed wrote:
> Hi,
>
> Do you want to chek whether the master file ph.# are callable or
> non-callable by verying it with NDNC sheet?
>
>
>
> On Sat, Mar 3, 2012 at 4:16 AM, Satvik wrote:
>
>> Hi Every One,
>>
>> Friend I need a b
Hi,
Do you want to chek whether the master file ph.# are callable or
non-callable by verying it with NDNC sheet?
On Sat, Mar 3, 2012 at 4:16 AM, Satvik wrote:
> Hi Every One,
>
> Friend I need a big help from you all, as I work in BPO company as a MIS
> executive but I am not aware about Acce
Hi Every One,
Friend I need a big help from you all, as I work in BPO company as a MIS
executive but I am not aware about Access or SQL. But every day I need to scrub
the NDNC data which I receive it from my client side.. Volume of a data will be
around 5 to 6 lake. Where I get NDNC scrubbed fi
Try Sumif
Kantilal Badale
On Mon, Feb 27, 2012 at 6:02 PM, Arpita kapoor wrote:
> Hi,
>
> Can anyone please help me with a simple formula for the below data set.
> All I need is to a sum of all the figures (+/-) except for those which are
> =><1/-1
>
>0.47 0.40 0.26 1.05 0.21 2.50 0.0
Hi Arpita,
You can also use..
SUMPRODUCT((A1:A16>0)*(A1:A16))
On Mon, Feb 27, 2012 at 6:02 PM, Arpita kapoor wrote:
> Hi,
>
> Can anyone please help me with a simple formula for the below data set.
> All I need is to a sum of all the figures (+/-) except for those which are
> =><1/-1
>
>0.
Hi,
Try below formula with Ctrl+Shift+Enter.
=SUM(IF(A1:A16>0,A1:A16,0))
Find the attached file.
Regards,
MARIES.
On Mon, Feb 27, 2012 at 4:32 PM, Arpita kapoor wrote:
> =><
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titl
Hi,
Can anyone please help me with a simple formula for the below data set. All I
need is to a sum of all the figures (+/-) except for those which are =><1/-1
0.47
0.40
0.26
1.05
0.21
2.50
0.05
-0.03
-0.07
-0.08
-0.31
-0.48
-0.65
-0.66
-0.80
-11.26
I don't seem to get it, I am s
Dear Pravesh,
You can use lookup too
VLOOKUP(I13:I19,D11:E24,2)
From: PRAVESH KUMAR
To: excel-macros@googlegroups.com
Sent: Friday, 3 February 2012 11:06 PM
Subject: $$Excel-Macros$$ Urgent Help
Hi,
please help ASAP.
please find attached sheet
Hi Noorain,
Thanks a lot of...
On 2/3/12, NOORAIN ANSARI wrote:
> Dear Pravesh,
>
> See attached sheet..
>
> =SUMPRODUCT(($D$5:$D$18=K7)*($F$5:$F$18=2)*($E$5:$E$18))
>
> On Fri, Feb 3, 2012 at 11:30 PM, Sam Mathai Chacko
> wrote:
>
>> This should work
>>
>> =INDEX($D$5:$D$18
OK. Here is another way AFTER sorting the source table
INDEX(E:E,MATCH(I6,D:D))
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Sam Mathai Chacko
Sent: Friday, February 03, 2012 12:00 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Urgent Help
This should work
Dear Pravesh,
See attached sheet..
=SUMPRODUCT(($D$5:$D$18=K7)*($F$5:$F$18=2)*($E$5:$E$18))
On Fri, Feb 3, 2012 at 11:30 PM, Sam Mathai Chacko wrote:
> This should work
>
> =INDEX($D$5:$D$18,SMALL(IF($D$5:$D$18<>OFFSET($D$5:$D$18,1,0),ROW(INDIRECT("1:"&ROWS($D$5:$D$18))),""),COUNTA($I$4:I4)))
>
I second Don. please keep in mind that the volunteers here 'lend' their
time to the forum to help. So it would be best to give that extra bit of
information in a clear and concise manner, so that it is easy for the
volunteers.
Sam
On Fri, Feb 3, 2012 at 11:30 PM, Sam Mathai Chacko wrote:
> T
This should work
=INDEX($D$5:$D$18,SMALL(IF($D$5:$D$18<>OFFSET($D$5:$D$18,1,0),ROW(INDIRECT("1:"&ROWS($D$5:$D$18))),""),COUNTA($I$4:I4)))
Regards,
Sam Mathai Chacko
On Fri, Feb 3, 2012 at 11:06 PM, PRAVESH KUMAR wrote:
> Hi,
>
>
> please help ASAP.
>
> please find attached sheet.
>
>
> Thanks
>
>
-
From: PRAVESH KUMAR
Sent: Friday, February 03, 2012 11:36 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Urgent Help
Hi,
please help ASAP.
please find attached sheet.
Thanks
Pravesh Kumar
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate
Hi,
please help ASAP.
please find attached sheet.
Thanks
Pravesh Kumar
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
q
Hi Paul,
Can you do a favour for me ?
ping me your mail ID at: excelfox at live.in
Kris
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
It appears that Paul has solved it for you.
Don Guillett
SalesAid Software
dguille...@gmail.com
From: nitin arora
Sent: Wednesday, January 04, 2012 7:52 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Urgent help required
Hi Don,
My apologies for the subject and I promise
---
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-------------
From: nitin
Hi
Do you want this procedure Only in AB Column..?
Regards
Rajan
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of nitin arora
Sent: Jan/Wed/2012 12:51
To: excel-macros
Subject: $$Excel-Macros$$ Urgent help required
Hi,
Please find attached
ged or do you want a list on another
> sheet?, etc.
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> *From:* nitin arora
> *Sent:* Wednesday, January 04, 2012 1:20 AM
> *To:* excel-macros
> *Subject:* $$Excel-Macros$$ Urgent help required
>
>
>
where you want the
data? Do you want the file changed or do you want a list on another sheet?, etc.
Don Guillett
SalesAid Software
dguille...@gmail.com
From: nitin arora
Sent: Wednesday, January 04, 2012 1:20 AM
To: excel-macros
Subject: $$Excel-Macros$$ Urgent help required
Hi,
Please find
Hi,
Please find attached excel sheet named Errors Bifurcation.
In this sheet there are many columns in which errors have been reported
seperated by commas. I want that all the errors seperated by commas should
appear in seperate rows with the data for Target ID and Tranaction ID. For
example:
In
1 - 100 of 249 matches
Mail list logo
