Fwd: $$Excel-Macros$$ Formula for Sum of nearest target value

-- Forwarded message -- From: Dheeraj Bankoti Date: Mon, Apr 18, 2016 at 7:22 AM Subject: Fwd: $$Excel-Macros$$ Formula for Sum of nearest target value To: excel-macros@googlegroups.com It seems now there is no excitement in group to help. Regards Dheeraj

Re: $$Excel-Macros$$ Formula for Sum of nearest target value

heeraj Bankoti > Date: Thu, Apr 14, 2016 at 11:24 AM > Subject: $$Excel-Macros$$ Formula for Sum of nearest target value > To: excel-macros@googlegroups.com > > > Dear Experts, > I am seeking formula for sum of nearest target value and its date in > attached file. > >

$$Excel-Macros$$ Formula to Replace 2nd List with Master List

Hello Experts, In the file attached, i have a master list with names and codes(master sheet), and then another list (list sheet). The codes in the master sheet does not match with that of the other list, so i used the normal index and match to retrieve the different values, the issue is that i wan

Re: $$Excel-Macros$$ Formula to find items between two dates *

Thanks Experts, i have aadjusted my formula, its working now. thanks On Fri, Feb 1, 2013 at 11:36 AM, Hilary Lomotey wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (resp...@gmail.com) Add cleanup > rule

Re: $$Excel-Macros$$ Formula to find items between two dates

Hi Hilary, Please see the attachment, Hope it will meet your expectation. -- With Regards, Noorain Ansari http:// noorainansari.com http:// excelvbaclinic.com

Re: $$Excel-Macros$$ formula into one row, data from oracle

Thanks Anil, For your quick response, but on your suggestion only single row, i want the formula can handle entire row below (description and receipt number column) thanks a lot Pada Senin, 25 Februari 2013 14:36:56 UTC+8, अनिल नारायण गवली menulis: > > Dear Iskandar, > > Pl see the attache

$$Excel-Macros$$ Formula to highlight planned leave by Conditional formating

Hi Team, Please refer the Sheet in which I need a formula which can calculate and show the planned leaves in date format and should highlight in Red. Thanks & Regards, Lucky -- 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 Facebo

$$Excel-Macros$$ Formula for calculate max number for unique values

Dear All, How can we develop a Formula for calculate max number in unique values like if we have 1000 total values and 10 values are unique in this data. I have needed a single formula which can calculate unique values max number (problem is all 1000 values in a single column and their number in ot

$$Excel-Macros$$ Formula for calculate max number for unique values

On Nov 2, 2013 9:03 AM, "Ali Abbas" wrote: > Dear All, How can we develop a Formula for calculate max number in unique > values like if we have 1000 total values and 10 values are unique in this > data. I have needed a single formula which can calculate unique values max > number (problem is all

$$Excel-Macros$$ Formula to fetch employee names based on time

Friends, > I have a file, wherein I have times when employees are scheduled to work. These times are in PST. > I have a table where I have noted the hours of a day in different timezones. > All I need is a formula (not VBA) that will show the corresponding employee name(s) working on that hour bas

Re: $$Excel-Macros$$ Formula require for Conditional and Lookup data-

Dear all experts, Is my query is valid ? can we lookup the closest data as like the attachment earlier. Please help on the attachment. Thanks to all. With warm regards, Rajan Sharma On Thu, Nov 14, 2013 at 9:49 AM, Rajan sharma wrote: > Sorry- attachment missed > Dear experts, > > >

Re: $$Excel-Macros$$ Formula require for Conditional and Lookup data-

Dear Ranjan, Are You want delete all the rows which contain orange data in column E. in sheet one. Thanks, Ashish On Thursday, 14 November 2013, Rajan sharma wrote: > Dear all experts, > > Is my query is valid ? can we lookup the closest data as like the > attachment earlier. Please h

Re: $$Excel-Macros$$ Formula require for Conditional and Lookup data-

Dear rajan, Pl elaborate more on this query Warm Regards, Gawli Anil Thanks & Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Thu, Nov 14, 2013 at 11:57 AM, Rajan sharma wrote: > Dear all experts, > > Is my query is valid ? can we lookup the closes

Re: $$Excel-Macros$$ Formula require for Conditional and Lookup data-

Dear Sirs, I want to find the Closest match from A and D column. i mean if the word contains in A column similar to D column (it may be 1st , 2nd or any middle line or last line) then the closest matches should be lookup. I hope i could able to explain you all experts, Thanks to all for

Re: $$Excel-Macros$$ Formula require for Conditional and Lookup data

attachment missing . Enjoy Team XLS On Thu, Nov 14, 2013 at 9:46 AM, Rajan sharma wrote: > Dear experts, > > > I am unable to write the formula for the attached excel file. > Please help me to create formula please..i have tried many a times, but > unable to w

Re: $$Excel-Macros$$ formula required for count or count if

Hi Sara, Seems formula COUNTIF can solve your problem simply. 2012/4/27 Sara Lee > hi > > i have data as in the attached data. i need count of unique values of > column A i.e i need output as in column AB, AC... pls advise a formula > thanks > > -- > FORUM RULES (986+ members already BANNED

Re: $$Excel-Macros$$ formula required for count or count if

Actually count of values stored in adjacent columns of each load number is required. For Load 0241 - there are 6 values so the formula should return 6. On Fri, Apr 27, 2012 at 1:09 PM, Darwin Chan wrote: > Hi Sara, > > Seems formula COUNTIF can solve your problem simply. > > 2012/4/27 Sara Lee

Re: $$Excel-Macros$$ formula required for count or count if

yes i need count of distinct records for each load no-- sample output load 02416 load 02423 load 02452 load 02462 On Fri, Apr 27, 2012 at 3:45 AM, Abhishek Jain wrote: > Actually count of values stored in adjacent columns of each load number is > required. For Loa

Re: $$Excel-Macros$$ formula required for count or count if

you can use =SUMPRODUCT(--($A$2:$A$23=AB2)) On Fri, Apr 27, 2012 at 1:26 PM, Sara Lee wrote: > yes i need count of distinct records for each load no-- sample output > > load 02416 > load 02423 > load 02452 > load 02462 > > > On Fri, Apr 27, 2012 at 3:45 AM, Ab

Re: $$Excel-Macros$$ formula required for count or count if

it is not working-- anybody else can help here On Fri, Apr 27, 2012 at 4:06 AM, anil panchal wrote: > you can use > > =SUMPRODUCT(--($A$2:$A$23=AB2)) > > > > > On Fri, Apr 27, 2012 at 1:26 PM, Sara Lee wrote: > >> yes i need count of distinct records for each load no-- sample output >> >> load

Re: $$Excel-Macros$$ formula required for count or count if

sara, the formula should workfirst highlight the range you want to implement this formula, then you should try Ctrl + Shift + Enter. 2012/4/27 Sara Lee > it is not working-- anybody else can help here > > > On Fri, Apr 27, 2012 at 4:06 AM, anil panchal wrote: > >> you can use >> >> =SUMPROD

Re: $$Excel-Macros$$ formula required for count or count if

should i paste in AB2? On Fri, Apr 27, 2012 at 4:52 AM, Darwin Chan wrote: > sara, > > the formula should workfirst highlight the range you want to implement > this formula, then you should try Ctrl + Shift + Enter. > > > 2012/4/27 Sara Lee > >> it is not working-- anybody else can help here

Re: $$Excel-Macros$$ formula required for count or count if

thee are two similar rows with same load no---this is not working On Fri, Apr 27, 2012 at 4:06 AM, anil panchal wrote: > you can use > > =SUMPRODUCT(--($A$2:$A$23=AB2)) > > > > > On Fri, Apr 27, 2012 at 1:26 PM, Sara Lee wrote: > >> yes i need count of distinct records for each load no-- sample

Re: $$Excel-Macros$$ formula required for count or count if

See if you understand array formula. http://www.excelfunctions.net/Excel-Array-Formulas.html 2012/4/27 Sara Lee > thee are two similar rows with same load no---this is not working > > On Fri, Apr 27, 2012 at 4:06 AM, anil panchal wrote: > >> you can use >> >> =SUMPRODUCT(--($A$2:$A$23=AB2)) >>

Re: $$Excel-Macros$$ formula required for count or count if

Dear Sara, Its Working Fine please find the attached file. Thanks & Regards Anil Kumar 113784 On Fri, Apr 27, 2012 at 2:52 PM, Darwin Chan wrote: > See if you understand array formula. > > http://www.excelfunctions.net/Excel-Array-Formulas.html > > > 2012/4/27 Sara Lee > >> thee are two si

Re: $$Excel-Macros$$ formula required for count or count if

Anil it s not the count of loads.. i need the count of distinct values for every load no ie Load 0241 7151865O 7154687O 7175843O 7202990O 7212856O 7253406O has 6 values both from top row and bottom row.. so 6 should be the output for load 0241 in some case as u see, some loads have 3 ro

Re: $$Excel-Macros$$ formula required for count or count if

no but this takes duplicates into consideration.. I would need count of only unique values for every load no On Fri, Apr 27, 2012 at 7:39 AM, Shaik Waheed wrote: > Hi Sara, > > PFA, Hope this is what you are looking for... > > On Fri, Apr 27, 2012 at 4:33 PM, Sara Lee wrote: > >> Anil >

Re: $$Excel-Macros$$ formula required for count or count if

Hi Sara, PFA Regards Lalit Mohan https://www.facebook.com/buzinesstransformation On 4/27/2012 10:00 AM, Sara Lee wrote: hi i have data as in the attached data. i need count of unique values of column A i.e i need output as in column AB, AC... pls advise a formula thanks -- FORUM RULES

Re: $$Excel-Macros$$ formula for showing multiple of a no.

'm not sure if the rest of your formula is correct... But this will at least get your first question answered... Paul From: Sastry To: MS EXCEL AND VBA MACROS Sent: Fri, February 19, 2010 12:44:25 PM Subject: $$Excel-Macros$$ formula for showing multiple o

Re: $$Excel-Macros$$ formula for showing multiple of a no.

eturns the > REMAINDER. > > So, you could use:  =if(mod(A2,6)=0,(B2*C2)+B2,B2) > > although I'm not sure if the rest of your formula is correct... > But this will at least get your first question answered... > Paul > ____ > From: Sastry >

Re: $$Excel-Macros$$ formula for showing multiple of a no.

and returns > the > > REMAINDER. > > > > So, you could use: =if(mod(A2,6)=0,(B2*C2)+B2,B2) > > > > although I'm not sure if the rest of your formula is correct... > > But this will at least get your first question answered... > > Paul > > _

$$Excel-Macros$$ Formula to monitor profit/loss in stocks trading

Dear all I use the attached excel sheet to calculate the profit/loss in the trading of individual stocks. The formula works fine in normal cases. But whenever there is some bonus/stock split etc. it fails. Can someone help me to derive a formula that will suit all cases? -- Regards Yahya --

$$Excel-Macros$$ Formula to retrieve only numbers in a Cell

Hi All, I need some help. I have a cell where there is Account Number and Cust Name and a codification before the Acct Num. *PlanGroup* P#C1299 J L Morison (India) Ltd I would like a formula that is taking only numbers from this cell. Could you help with this ? Thanks -- Regards Nou

$$Excel-Macros$$ Formula of the week - share your best formula

Dear Group, Let's discuss excel formula this week. Each of us use many formulas in our excel reports , dashboard metrics etc. Please share your best formula and the reason for being the best. If all of you will share atleast one formula, Then I hope to cover all formulas in excel. :D My one of

$$Excel-Macros$$ Formula of the week - share your best formula

Hi All, >From My Side, Best Formula is Match() Regards, Rajesh. Nair -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Li

Re: $$Excel-Macros$$ formula to add date in next column

put this code into sheets' module Private Sub Worksheet_Change(ByVal Target As Range) ' siti Vi ' jakarta, 11 mar 2011 ' If Target.Count = 1 Then If Target.Column = 1 Then If Target.Row > 1 Then If Len(Target) > 0 Then

Re: $$Excel-Macros$$ formula to add date in next column

Hey STDEV(i), Thanks a lot but i dont want macro, i want formula for it. Let me know if is there any formula for this. Regards, Hemant On Sun, Mar 13, 2011 at 1:04 PM, STDEV(i) wrote: > put this code into sheets' module > > Private Sub Worksheet_Change(ByVal Target As Range) >' siti Vi >

RE: $$Excel-Macros$$ formula to add date in next column

Hi Hemant, I don't think there's a non-macro solution for this. Regards - Dave. From: coolh...@gmail.com Date: Sun, 13 Mar 2011 23:36:21 +0530 Subject: Re: $$Excel-Macros$$ formula to add date in next column To: excel-macros@googlegroups.com Hey STDEV(i), Thanks a lot but i dont

Re: $$Excel-Macros$$ formula to add date in next column

let us be very patient, & waiting for some one who give a formula that can write a Constat_Date into a cell On Mon, Mar 14, 2011 at 1:06 AM, Hems wrote: > Hey STDEV(i), > > Thanks a lot but i dont want macro, i want formula for it. > > Let me know if is there any formula for this. > > Regards,

RE: $$Excel-Macros$$ formula to add date in next column

Hi, After deciding that this was impossible, an idea came to me while I was in the shower. See the attached. B2 and B3 have data, so C2 and C3 should show the data entry date of 16 March 2011, no matter when the file is viewed. If you enter data into B4, the current date should appear in C4, and

$$Excel-Macros$$ Formula Evaluator Shows Text but comes out blank

Hello Again, There is something funny going on in the formula in the attached sheet. in column B34 i have written a formula INDEX($W$3:$W$667,MATCH(U3,$V$3:$V$667,0)) to pick up the value from a list however the outcome comes with a dash (-), however if i run formula evaluator, you can see it pick

$$Excel-Macros$$ Formula to Separate Company name and Email Address

Hi Team, I am looking for a formula to separate Company's name and email address from IDs. Please refer the snap shot below IDS Company Email Address Accord Soft asiapaci...@accord-soft.com

$$Excel-Macros$$ Formula to grab last two words from string

I have a string such as the following two examples and want a formula to grab the last two words. The following formula works for me but I'm looking for other ways to do the same. =MID(A1,FIND("-Date",A1)+6,LEN(A1)) Any help would be appreciated Cell A1 contains: Reporting Period: Month-T

$$Excel-Macros$$ Formula need to calculate sum on conditional base

Dear expert, I have a data in attached sheet, in which data contain opng balance, transaction & closing balance of particular month and code, i need a formula to calculate sum opening balance of month wise on base of code, the data file is attached herewith for my requirement. Thanks & regards.

$$Excel-Macros$$ Formula needed to extract the text from string

Hi Expert, I needed the formula which can extract the specific content from a Text, below is some sample excel cells To simplify this there is "/" sign after each content, and I need exact data which start after 4th "/" and till 5th "/" (which is mention below in Red). Can anybody tell me the

Re: $$Excel-Macros$$ Formula to find Maximum number from list

hi ashish use =MAX(--REPLACE(A2:A41,1,9,"")) with CSE On Wed, Feb 8, 2012 at 4:18 PM, Ashish Bhalara wrote: > Dear expert, > > I want to formula of maximum number find from a different list which > example attached herewith. > > Thanks & regards > > Ashish Bhalara > > -- > FORUM RULES (986+ m

Re: $$Excel-Macros$$ Formula to find Maximum number from list

Maximum number is 1003, not display in your formula On Wed, Feb 8, 2012 at 4:49 PM, The Viper wrote: > hi ashish > > use =MAX(--REPLACE(A2:A41,1,9,"")) with CSE > > > On Wed, Feb 8, 2012 at 4:18 PM, Ashish Bhalara > wrote: > >> Dear expert, >> >> I want to formula of maximum number find from

Re: $$Excel-Macros$$ Formula to find Maximum number from list

its working fine. now i have wrote two types of formulas go through the attachment. On Wed, Feb 8, 2012 at 4:53 PM, Ashish Bhalara wrote: > Maximum number is 1003, not display in your formula > > > On Wed, Feb 8, 2012 at 4:49 PM, The Viper wrote: > >> hi ashish >> >> use =MAX(--REPLACE(A2:A41,

$$Excel-Macros$$ formula that runs IF functions based upon changing identifiers

Hello I need some help: I have a spread sheet with dozens of thousands of unique identifies (Subscriber IDs). Each one represents a person. Some people were billed for a coverage periods and some people's billing for a coverage period was skipped. Now I have to figure out which people need to

$$Excel-Macros$$ Formula to find the month btwn the financial year

Dear team, Need a help on formula to find the month btwn the years.. pls find the attachement. Note: its should calculate from Apr - Mar I tried but I not able to get the correct one. Thanks & Regards, Ganesh N -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIM

$$Excel-Macros$$ Formula to populate cells and sum in adjacent cell

Hi Guys, I want a formula that populates values in a worksheet, on a single row based on two values entered on a different worksheet. The formula should then sum the populated cells and input the result in the cell adjacent to the last cell entry. Example: I want to fill 9 cells in sheet2 with

Re: $$Excel-Macros$$ Formula to Replace 2nd List with Master List *

NO WORRIES, I SOLVED IT, THANKS On Thu, Jan 24, 2013 at 12:00 PM, Hilary Lomotey wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (resp...@gmail.com) Add cleanup > rule

Re: $$Excel-Macros$$ Formula to Replace 2nd List with Master List

At D3 of sheet List you can use the formula: =IF(A3="";"";VLOOKUP(A3;MASTER!$A$3:$B$9;2;0)) And Fill down, See Attachment 2013/1/24, Hilary Lomotey : > Hello Experts, > > In the file attached, i have a master list with names and codes(master > sheet), and then another list (list sheet). The code

Re: $$Excel-Macros$$ Formula to Replace 2nd List with Master List

Dear betnmtdongnai, what is use of ("";"";) in formula .as like Prince simple vlookup aslo got answer On Thu, Jan 24, 2013 at 9:21 PM, Bé Trần Văn wrote: > At D3 of sheet List you can use the formula: > > =IF(A3="";"";VLOOKUP(A3;MASTER!$A$3:$B$9;2;0)) > > And Fill down, See Attachment > > 2013/1/

Re: $$Excel-Macros$$ Formula to Replace 2nd List with Master List

I ""; "" to ignore the error # N/A if column A MASTER of 2 LIST list and the elements are not the same, you try. 2013/1/25, amar takale : > Dear betnmtdongnai, > what is use of ("";"";) in formula .as like Prince simple vlookup aslo > got answer > > On Thu, Jan 24, 2013 at 9:21 PM, Bé Trần Văn >

Re: $$Excel-Macros$$ Formula to Replace 2nd List with Master List

ok,thanks for reply On Sat, Jan 26, 2013 at 6:02 AM, Bé Trần Văn wrote: > I ""; "" to ignore the error # N/A if column A MASTER of 2 LIST list > and the elements are not the same, you try. > > 2013/1/25, amar takale : >> Dear betnmtdongnai, >> what is use of ("";"";) in formula .as like Prince si

Re: $$Excel-Macros$$ Formula to highlight planned leave by Conditional formating

Do you want to show date rather than "L" sign? On Mon, Aug 26, 2013 at 7:36 PM, Zibraan wrote: > Hi Team, > > Please refer the Sheet in which I need a formula which can calculate and > show the planned leaves in date format and should highlight in Red. > > > Thanks & Regards, > Lucky > > -- > A

Re: $$Excel-Macros$$ Formula to highlight planned leave by Conditional formating

NO actually i want to show L whichever dates he have taken leave. But it should be automated by formula so that i just need to enter the dates in the sheet named "Database" and it will automatically highlights those dates in red in sheet "Summary" and the previous leave dates would be available wi

Fwd: $$Excel-Macros$$ Formula to highlight planned leave by Conditional formating

Hi Team, Awaited for your expertise advice. Thanks & Regards, Lucky S -- Forwarded message -- From: Zibraan Date: Mon, Aug 26, 2013 at 7:36 PM Subject: $$Excel-Macros$$ Formula to highlight planned leave by Conditional formating To: excel-macros@googlegroups.com Hi

RE: $$Excel-Macros$$ Formula for calculate max number for unique values

PFA with two solution, if you are looking for this. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ali Abbas Sent: Saturday, November 02, 2013 2:33 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Formula for calculate max number for

Fwd: $$Excel-Macros$$ Formula to fetch employee names based on time

*PLEASE HELP!!!* -- Forwarded message -- From: Abhishek Jain Date: Wed, Nov 13, 2013 at 10:16 AM Subject: $$Excel-Macros$$ Formula to fetch employee names based on time To: MS EXCEL AND VBA MACROS Friends, > I have a file, wherein I have times when employees are scheduled

Re: $$Excel-Macros$$ Formula to fetch employee names based on time

Hi Abhishek, Can you please be more clear on your request, so that we can try to solve your query Regards, Kartik On Wed, Nov 13, 2013 at 10:16 AM, Abhishek Jain wrote: > Friends, > > > I have a file, wherein I have times when employees are scheduled to > work. These times are in PST. > > I ha

Re: $$Excel-Macros$$ Formula to fetch employee names based on time

Dear Kartik, Thanks for your reply. All I want is when I select the timezone and the day, the employees working through the day would appear along with times. Let me know if any further clarification is needed. Regards...Abhishek On Mon, Nov 18, 2013 at 5:27 PM, Kartik Dale wrote: > Hi Abhi

Re: $$Excel-Macros$$ Formula of the week - share your best formula

yush To: excel-macros@googlegroups.com Sent: Tue, January 11, 2011 10:04:30 PM Subject: $$Excel-Macros$$ Formula of the week - share your best formula Dear Group, Let's discuss excel formula this week. Each of us use many formulas in our excel reports , dashboard metrics etc. Please share

Re: $$Excel-Macros$$ Formula of the week - share your best formula

Ayush > *To:* excel-macros@googlegroups.com > *Sent:* Tue, January 11, 2011 10:04:30 PM > *Subject:* $$Excel-Macros$$ Formula of the week - share your best formula > > Dear Group, > > Let's discuss excel formula this week. Each of us use many formulas in our > excel reports

Re: $$Excel-Macros$$ Formula of the week - share your best formula

--- >> *From:* Ayush >> *To:* excel-macros@googlegroups.com >> *Sent:* Tue, January 11, 2011 10:04:30 PM >> *Subject:* $$Excel-Macros$$ Formula of the week - share your best formula >> >> Dear Group, >> >> Let's discuss excel formula this week. Each of

Re: $$Excel-Macros$$ Formula of the week - share your best formula

Hi Ayush, One of my *Best* formula is *OFFSET*. Reason:- It can be used in getting the desired value (located) anywhere in the spreadhseet, the desired Sum, Average etc. It is also used for creating dynamics ranges - which further can be used in formulas / conditional formatting. Best Regards,

Re: $$Excel-Macros$$ Formula of the week - share your best formula

Hi Ayush Ji, My formulas are *CHOOSE -* we can rank the candidates with choose & code combination CHOOSE(CODE(B1)-64,"Excellent","Best","Poor"), if B1has the value A, B, or C. *CELL("FILENAME",A1) - *we can get instant result of the path of the current file with sheet name. *REPT - *This one g

RE: $$Excel-Macros$$ Formula of the week - share your best formula

Hi Ayush, There seems to be some confusion. I thought the question related to our favourite formula, not favourite function. Please clarify. Regards - Dave. From: rohan.j...@gmail.com Date: Wed, 12 Jan 2011 16:01:19 +0530 Subject: Re: $$Excel-Macros$$ Formula of the week - share your best

RE: $$Excel-Macros$$ Formula of the week - share your best formula

Subject: Re: $$Excel-Macros$$ Formula of the week - share your best formula Hi Ayush Ji, My formulas are CHOOSE - we can rank the candidates with choose & code combination CHOOSE(CODE(B1)-64,"Excellent","Best","Poor"), if B1has the value A, B, or C.

Re: $$Excel-Macros$$ Formula of the week - share your best formula

PM Subject: Re: $$Excel-Macros$$ Formula of the week - share your best formula Hi Ayush, One of my Best formula is OFFSET. Reason:- It can be used in getting the desired value (located) anywhere in the spreadhseet, the desired Sum, Average etc. It is also used for creating dynamics ranges

Re: $$Excel-Macros$$ Formula of the week - share your best formula

e clarify. > Regards - Dave. > > -- > From: rohan.j...@gmail.com > Date: Wed, 12 Jan 2011 16:01:19 +0530 > > Subject: Re: $$Excel-Macros$$ Formula of the week - share your best formula > To: excel-macros@googlegroups.com > CC: jainayus...@gmail.com &g

Re: $$Excel-Macros$$ Formula of the week - share your best formula

>> favourite formula, not favourite function. Please clarify. >> Regards - Dave. >> >> -- >> From: rohan.j...@gmail.com >> Date: Wed, 12 Jan 2011 16:01:19 +0530 >> >> Subject: Re: $$Excel-Macros$$ Formula of the week - shar

Re: $$Excel-Macros$$ Formula of the week - share your best formula

Dear members, We all come to know about many functions & their best uses. Please keep sharing. Thanks. Best Regards, Ayush Jain -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks an

Re: $$Excel-Macros$$ Formula of the week - share your best formula

Hi All, I suggest all of you don't say this function I like and then this one like that. Just sharing the function name won't help others to gain some knowledge. All the functions which is available in excel is having the same set of qualities unless it is used in perfect combination. So give b

Re: $$Excel-Macros$$ Formula of the week - share your best formula

hi 1 case sensitive lookup using index and match 2 vlookup & indirect function Check the attachment. Given you the situations where I used them in the past On Thu, Jan 13, 2011 at 11:15 PM, Ms-Exl-Learner . wrote: > Hi All, > > I suggest all of you don't say this function I like and then thi

Re: $$Excel-Macros$$ Formula of the week - share your best formula

One of the function which I do like is "TRANSPOSE" function. - This function copies data from a range, and places in it in a new range, turning it so that the data originally in columns is now in rows, and the data originally in rows is in columns. - The transpose range must be the same size as t

Re: $$Excel-Macros$$ Formula of the week - share your best formula

Dear Ashish, I am unable to find data through Vlookup+indirect when sheet name is Date wise like 14-Jan,15-Jan,16-Jan. Please see attached sheet.. -- Thanks & regards, Noorain Ansari On Thu, Jan 13, 2011 at 9:49 PM, ashish koul wrote: > hi > 1 case sensitive lookup using index and match

RE: $$Excel-Macros$$ Formula of the week - share your best formula

Hi, The problem is not the sheet names, but the indirect refering to a date, which is really just a date code, not a date as displayed. Regards - Dave. Date: Thu, 13 Jan 2011 23:08:24 -0800 Subject: Re: $$Excel-Macros$$ Formula of the week - share your best formula From: noorain.ans

Re: $$Excel-Macros$$ Formula of the week - share your best formula

> Regards - Dave. > > -- > Date: Thu, 13 Jan 2011 23:08:24 -0800 > > Subject: Re: $$Excel-Macros$$ Formula of the week - share your best formula > From: noorain.ans...@gmail.com > > To: excel-macros@googlegroups.com > CC: koul.ash...@gmail.co

RE: $$Excel-Macros$$ Formula of the week - share your best formula

P for you to have a look at. Regards - Dave Date: Fri, 14 Jan 2011 01:53:41 -0800 Subject: Re: $$Excel-Macros$$ Formula of the week - share your best formula From: noorain.ans...@gmail.com To: excel-macros@googlegroups.com Hi Dave, How can solve it. Please give ur valauble suggestion.. Thank

RE: $$Excel-Macros$$ Formula of the week - share your best formula

NSARI Sent: Friday, January 14, 2011 12:38 PM To: excel-macros@googlegroups.com Cc: ashish koul Subject: Re: $$Excel-Macros$$ Formula of the week - share your best formula Dear Ashish, I am unable to find data through Vlookup+indirect when sheet name is Date wise like 14-Jan,15-Jan,16-Ja

Re: $$Excel-Macros$$ Formula of the week - share your best formula

Mine Fav Formula this week is =COUNTIF(A$3:A3,A3) It resolved my headache...Give ranking n order number for repetitive values Love tht one -- -- Some important links for excel users: 1. Follow us on TWITTER for ti

RE: $$Excel-Macros$$ Formula that will add on next cell's data

@googlegroups.com Subject: Re: $$Excel-Macros$$ Formula that will add on next cell's data Hi Susan, Formula in cell D3 sheet Apr 2011 =SUM('Mar 2011'!$B$38,$B$3:B3)/E3 and then drag it down see examples in sheets Jan upto Apr 2011 On Sat, Mar 12, 2011 at 2:50 AM, Susan

Re: $$Excel-Macros$$ Formula Evaluator Shows Text but comes out blank

You have a circular reference. The formulas in col W refer to a range including the cell B34 which refers to cells in col W. I don't really understand quite what you are doing so I do not offer a solution but I hope this will help you find one for yourself. Regards David Grugeon On 31 July 2012

Re: $$Excel-Macros$$ Formula Evaluator Shows Text but comes out blank

thanks Dave On Tue, Jul 31, 2012 at 12:48 PM, David Grugeon wrote: > You have a circular reference. The formulas in col W refer to a range > including the cell B34 which refers to cells in col W. > > I don't really understand quite what you are doing so I do not offer a > solution but I hope thi

Re: $$Excel-Macros$$ Formula Evaluator Shows Text but comes out blank

Hi Hilary Lomotey you have Custom Cell Formatting _(* #.##0,00_);_(* (#.##0,00);_(* "-"??_);_(@_) you must change by: _(* #.##0,00_);_(* (#.##0,00);_(* ""??_);_(@_) or another of your choice Chilexcel 2012/7/31 Hilary Lomotey > thanks Dave > > > On Tue, Jul 31, 2012 at 12:48 PM, David Grug

Re: $$Excel-Macros$$ Formula to Separate Company name and Email Address

Dear Zibraan, I think it is very difficult to separate company Name and ID. because criteria is changing with word by word. Excel Function can't recognize company name. If you provide specific criteria then it can be done. On Tue, Aug 28, 2012 at 2:50 PM, Zibraan wrote: > > Hi Team, > > I a

Re: $$Excel-Macros$$ Formula to Separate Company name and Email Address

Sure zibraan, Can you share a sample sheet. On Tue, Aug 28, 2012 at 3:47 PM, Zibraan wrote: > ok atleast can we extract email address > > > > On Tue, Aug 28, 2012 at 3:01 PM, NOORAIN ANSARI > wrote: > >> Dear Zibraan, >> >> I think it is very difficult to separate company Name and ID. because

Re: $$Excel-Macros$$ Formula to Separate Company name and Email Address

Hi Noorain It seems easy enough to create a UDF which finds the @ and then steps back until it finds a space. This will define the point to split the string. No time to do it at the moment. On 28 August 2012 20:39, Zibraan wrote: > > PFA... > > > On Tue, Aug 28, 2012 at 4:08 PM, NOORAIN ANSAR

Re: $$Excel-Macros$$ Formula to Separate Company name and Email Address

Hi Lucky, You can use text to column fuction and put delimited from @. Then you can manually replace com/net etc. Please seperate the if two mail addresses in one cell. Regards, KSAGAR On Tue, Aug 28, 2012 at 4:40 PM, David Grugeon wrote: > Hi Noorain > > It seems easy enough to create a UDF

Re: $$Excel-Macros$$ Formula to Separate Company name and Email Address

but it has more than 130 email addresses it is not possible manually... On Tue, Aug 28, 2012 at 5:28 PM, SAGAR KASANGOTTUWAR < sagarkasangottu...@gmail.com> wrote: > Hi Lucky, > > You can use text to column fuction and put delimited from @. Then you can > manually replace com/net etc. > > Pleas

Re: $$Excel-Macros$$ Formula to Separate Company name and Email Address

Hi Zibrean,, Please use below formula =TRIM(RIGHT(SUBSTITUTE(LEFT(A4,FIND(" ",A4&" ",FIND("@",A4))-1)," ",REPT(" ",99)),99)) On Tue, Aug 28, 2012 at 2:50 PM, Zibraan wrote: > > Hi Team, > > I am looking for a formula to separate Company's name and email address > from IDs. > > Please refer the

Re: $$Excel-Macros$$ Formula to Separate Company name and Email Address

Hi, I´m sorry to be writing in this post, but I don´t think it is necessary to open a new post, because I have the same problem but my mail is between <>, I can I extract this? thanks On 28 August 2012 14:53, vijayajith VA wrote: > Hi Zibrean,, > > Please use below formula > > =TRIM(RIGHT(SUBSTI

Re: $$Excel-Macros$$ Formula to Separate Company name and Email Address

Dear Jorge HI U can try this.. =TRIM(RIGHT(SUBSTITUTE(LEFT(A4,FIND(" ",A4&" ",FIND("<>",A4))-1)," ",REPT(" ",99)),99)) If doesn't work share sample data. Cheers.. Regards//Vabs On Mon, Sep 17, 2012 at 8:49 PM, Jorge Marques wrote: > Hi, I´m sorry to be writing in this post, but I don´t thi

Re: $$Excel-Macros$$ Formula to Separate Company name and Email Address

Shorter one. In D2 =TRIM(RIGHT(SUBSTITUTE(SUBSTITUTE(LEFT(A2,FIND("@",A2)),CHAR(160)," ")," ",REPT(" ",99)),99))&LEFT(MID(A2,FIND("@",A2)+1,255)&" ",FIND(" ",MID(A2,FIND("@",A2)+1,255)&" ")-1) In E2 =TRIM(SUBSTITUTE(A2,D2,"")) Kris ExcelFox -- Join of

RE: $$Excel-Macros$$ Formula to Separate Company name and Email Address

Great J Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Krishna Kumar Sent: 17 September 2012 9:45 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Formula to Separate Company name and

$$Excel-Macros$$ formula required for addition of amount for duplicate entry

Dear All, I have an excel sheet wherein commission is generated for each business placed by our intermediary. I need to have a formula for monthly consolidated amount for Gross Amount (Column E) and TDS Deduction (Column I) of each intermediary without first sorting and subsequently adding each en

RE: $$Excel-Macros$$ Formula to grab last two words from string

ovember 2012 9:43 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Formula to grab last two words from string I have a string such as the following two examples and want a formula to grab the last two words. The following formula works for me but I'm looking for other ways

Re: $$Excel-Macros$$ Formula to grab last two words from string

Works Perfectly, Thanks! Rajan On Monday, November 19, 2012 11:40:26 AM UTC-5, Rajan_Verma wrote: > *If words are separated by Space use this* > > *=TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",LEN(A1))),LEN(A1)*2))** * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > -- Join offici

<    1   2   3   4   5   6   7   >