E
ExcelStudentSG
Good day dear members of ExcelBanter
ALBUM LINK:http://imgur.com/a/uXsa3#
I have a question where I have a the table in columns AT and AU wher
values in AT are static and the values in AU column vary
I would like to relist the values from AT and AU into AV and A
respectively by removing all entries that have a #NA value. What I nee
help with is the formula for the relisting in columns AV and AW startin
from the value '10'.
Put in another way, the formula will run through the columns AT and A
and look for the non-#NA entries, pick them out and relist them i
ascending order in columns AV and AW
I have included 3 different scenarios where it should look like i
successful.Thanks in advance for the help
Please ignore rows 6 and 22
ALBUM LINK:http://imgur.com/a/uXsa3#
I have a question where I have a the table in columns AT and AU wher
values in AT are static and the values in AU column vary
I would like to relist the values from AT and AU into AV and A
respectively by removing all entries that have a #NA value. What I nee
help with is the formula for the relisting in columns AV and AW startin
from the value '10'.
Put in another way, the formula will run through the columns AT and A
and look for the non-#NA entries, pick them out and relist them i
ascending order in columns AV and AW
I have included 3 different scenarios where it should look like i
successful.Thanks in advance for the help
Please ignore rows 6 and 22