$$Excel-Macros$$ Re: Introduce Yourself !!

2015-11-29 Thread GENIUS
Hi everyone I'm izhar, from Karachi-Pakistan, working as an accountant,47 years old. -- 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,

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

2015-11-29 Thread Dhartikumar Sahu
Hi I am Dhartikumar Sahu, working in IDBI CAPITAL as a Sr.Database Manager. On 29-Nov-2015 7:52 pm, "GENIUS" wrote: > > Hi everyone > I'm izhar, from Karachi-Pakistan, working as an accountant,47 years old. > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2

$$Excel-Macros$$ VLOOKUP Query

2015-11-29 Thread Shrinivas Shevde
Dear All I am using vlookup and facing following problem File attached thanks in advance -- Shrini -- 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

$$Excel-Macros$$ Re: question for searching

2015-11-29 Thread Mandeep Baluja
> > I am not sure what you're looking for,Therefore what i did is subtracting > the quantities of A:G - Subtracting the values of J:L Quantities, In H2 the > formula would be =G2-IFERROR(VLOOKUP(B2,$J$2:$L$47,3,0),0), but as I > checked your data contains duplicates, Do you wish to remove that

Re: $$Excel-Macros$$ Re: VLOOKUP Query

2015-11-29 Thread Shrinivas Shevde
Dear Mandeep thanks for reply but I could not understand which format shall I change which column Regards Shrinivas On Mon, Nov 30, 2015 at 10:34 AM, Mandeep Baluja wrote: > Keep the data in same format, number can't be equal to Text and text can't >> be equal to number,I put the data in same f