Hello,
Example:
A B C D E
0 0 4 0 C
In other words I need formula which will display in E column name of the column in case that cell of that column was bigger than 0. In above example Column E displays C because cell had number 4 .
Hello,
Example:
A B C D E
0 0 4 0 C
In other words I need formula which will display in E column name of the column in case that cell of that column was bigger than 0. In above example Column E displays C because cell had number 4 .
Either of these will return the column letter of the first greater-than-zero number in the range A1:A4:
Formula:Please Login or Register to view this content.
The first will start to break down if your A-D range extends beyond Z, the second should be okay. Neither of them will return more than one column result, though - only the first.
Edit: if your range starts in column B, the formulae would become:
Formula:Please Login or Register to view this content.
and so on if you start in C, etc.
Last edited by Aardigspook; 05-29-2017 at 03:34 PM. Reason: Add amendments needed if range starts in col B
Regards,
Aardigspook
I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
You don't need to give me rep if I helped, but a thank-you is nice.
Try
=CHAR(LOG(SIGN(A1)+SIGN(B1)*2+SIGN(C1)*4+SIGN(D1)*8,2)+65)
Martin
Do you not what? I did it in two steps:
STEP 1) I put filter on each column and selected non zero data
STEP 2) I copied name of the column to the first empty field in E a dragged down to all empty fields in E
Thank you for efforts
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks