Good evening, as the title suggests, I would like help for a formula that shows the abbreviations found in row 2 if the rows below have 0 values.
In column E the desired result.
Thank you
Good evening, as the title suggests, I would like help for a formula that shows the abbreviations found in row 2 if the rows below have 0 values.
In column E the desired result.
Thank you
Using your posted workbook...
If you had Excel 2019 or later you could use this regular formula (copied down)
However, if you don't, thenPlease Login or Register to view this content.
Copy this formula across through JR19Please Login or Register to view this content.
ThenPlease Login or Register to view this content.
Copy E19:JR19 down through E31Please Login or Register to view this content.
Is that something you can work with?
Note: Alternatively, a Power Query solution would be fairly easy.
Last edited by Ron Coderre; 12-23-2019 at 07:26 PM.
Hi Ron
thanks for your cooperation.
I wanted to kindly ask you if you could attach the file.
It doesn't give me the result I want.
Maybe something wrong happens to me in the translation.
Thanks again
P.s. no Power Query
OK...
I'm attaching my working copy.
Please let me know if that helps.
Yes, thanks
I was replying that I had solved by following your reasoning
and I found the file.
Thanks again for the help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks