Hi, I'd like to create a field which shows the Field Names for projects that have a value of 3 - is there a better and quicker way to do it than using IF formulas? Data Input: ProjectPiesCakesBreadTartsA3333B2311C1233D2323 Desired Output: ProjectPiesCakesBreadTartsValue of 3A3333Pies & Cakes & Bread & TartsB2311CakesC1233Bread & TartsD2323Cakes & Tarts Thanks!

Show field name based on Value

Hi,

I'd like to create a field which shows the Field Names for projects that have a value of 3 - is there a better and quicker way to do it than using IF formulas?

Data Input:

Project	Pies	Cakes	Bread	Tarts
A	3	3	3	3
B	2	3	1	1
C	1	2	3	3
D	2	3	2	3

Desired Output:

Project	Pies	Cakes	Bread	Tarts	Value of 3
A	3	3	3	3	Pies & Cakes & Bread & Tarts
B	2	3	1	1	Cakes
C	1	2	3	3	Bread & Tarts
D	2	3	2	3	Cakes & Tarts

Thanks!

Preparation

Accepted answers

MarqueeCrew

HM,

Thanks for the question. I've answered it with a module. I explained the solution within the module/pic. There's a spoiler alert! don't look down if you want to solve this yourself.

Thanks again for the puzzle. I hope that I solved it in a manner that will have business value for you.

Mark

Show field name based on Value.yxmd

All comments

MarqueeCrew

HM,

Thanks for the question. I've answered it with a module. I explained the solution within the module/pic. There's a spoiler alert! don't look down if you want to solve this yourself. Please note that I didn't join the data back to the input (final step in your request).

Thanks again for the puzzle. I hope that I solved it in a manner that will have business value for you.

Mark

Show field name based on Value.yxmd

MarqueeCrew

HM,

Thanks for the question. I've answered it with a module. I explained the solution within the module/pic. There's a spoiler alert! don't look down if you want to solve this yourself.

Thanks again for the puzzle. I hope that I solved it in a manner that will have business value for you.

Mark

Show field name based on Value.yxmd

Thank you! The solution was straight forward and very easy to understand thanks to your descriptions

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703