Dear All,
Please help me in excel formula. In the attached excel file, i want to get "Expense Head" in the column D with the help of formula where the value is more than "0".
Pls reply
Thank you.
what exactly you want explain
CHECK AND REPLY
Dear Ishan,
Thank you so much for your prompt reply. This is what i exactly want. But when the data are large, then is there any other way for the solution? Pls find attached large data file.
Thank you.
LET'S BE HAPPY . AS I DONE YOUR WORK EASY
ONE CAN ADD AS MUCH AS 256 ARGUMENTS IN EXCEL FORMULAS
Thank you so much, Mr. Ishan Aggarwal.
Mr. Ishan, great work. so you have entered every cell manually or is there any shortcut.??
Excel has limits on how deeply you can nest IF functions. Up to Excel 2007, Excel allowed up to 7 levels of nested IFs. In Excel 2007+, Excel allows up to 64 levels.
I have more than 64 levels. Above that excel does not allow to enter if formula
JUST ENTER 1 ARGUMENT AND
THEN COPY IT DESIRE NUMBER OF TIMES
THEN CORRECT THE CELL REFERENCE
THANKS
CAclubindia
