Forum Discussion
Shift cells up if false
Hia,
I've attached something that I think works for you.
- null nullSep 14, 2018Copper Contributor
Thanks for your response, Phillip.
I'm not sure I quite understand your images there, with the duplicate names in the list? I want the each list (y, n, blank) to list the names off with no gaps in between them. I'm also not sure what the second sheet is?
Sorry if I seem a bit dim, it's all new to me!
- Philip WestSep 14, 2018Iron Contributor
Hia, did you download the workbook? its an excel spread sheet rather than an image.
Ignore the second sheet, that was just some working out i did, didn't mean to include it.
If you look, there is the first table which is names and y/n/blanks and a second table with those sorted into columns without gaps. Which is what you are trying to do i think.
- bengarbarinoJun 20, 2022Copper Contributor
Hello,
I am trying to use your formula from the previous answer to update 4 columns for a work in progress list depending on if there is corresponding data (dates) in a table as a test and have gotten it to work. Is it possible to use this formula to apply it to a sheet that is not formatted as a table? Unfortunately, the sheet I need to pull the data for the WIP list can not be formatted as a table.
I attached a picture of the test that is working... the blue table is the WIP list showing the "name" field of the orange column moving from column to column depending on what dates are entered. You can also see the formula below the tables that is in cell J3.
Any help would be appreciated. I'm still a bit new to this so thank you in advance.
-Ben