Hi all,
I have a small table with 4 values. I'd like to take those values and format them into text based on how many values have something in them and if they have the same value or not.
For example:
A1 = 12
B1 = 13
C1 = blank
D1 = blank
I'd like a cell to read "(1) string of (12) & (1) string of (13)"
Next example:
A1 = 12
B1 = 12
C1 = blank
D1 = blank
In this case it should just say "(2) strings of (12)"
3rd example:
A1 = 12
B1 = 12
C1 = 13
D1 = blank
In this case it should just say "(2) strings of (12) & (1) string of (13)"
4th example:
A1 = 12
B1 = 12
C1 = 13
D1 = 13
In this case it should just say "(2) strings of (12) & (2) strings of (13)"
Final example:
A1 = 12
B1 = 12
C1 = 13
D1 = 15
In this case it should just say "(2) strings of (12), (1) string of (13) & (1) string of (15)"
I'm sure I could figure something out with a long list of IF statements, but I'm hoping there is something simpler.
Thank you for any advice or help!
Bookmarks