How to automatically relist values in separate column

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format column widths from one table to a separate table on same page 1
Setting column width in a table with a macro is not working 0
How to center adjust text above and image in a two column document. 1
Two columns followed by single page-width column on same page 0
countif with two criteria one a column of dates? 3
need help on either doing a loop and counting specific values orusing subtotal function 2
Calculate the median value before a specified list 0
Adding a big matrix in Word 2013 5

Top