I am trying to make gathering/Sorting and graphing some information a tad bit easier, so I wanted to create a table that had everything that I needed using if functions....I think I have that down, but I am ending up with a long list with a ton of blanks because not everything meets the criteria.....is there a way to eliminate the blanks and just move to the next cell if it doesn't work?
Example:
=IF(AND(Table!A3="Regional South",Table!R3="Pre P&L"),Table!CA3,"")
=IF(AND(Table!A3="Regional South",Table!R3="Post P&L"),Table!CA3,"")
=IF(AND(Table!A3="Major North",Table!R3="Pre P&L"),Table!CA3,"")
=IF(AND(Table!A3="Major North",Table!R3="Post P&L"),Table!CA3,"")
I am wanting to check two criteria, and if those are met, pull the data from another cell....if they aren't met, then it is currently leaving it blank. Instead of having a list with blanks in it, I am wanting to maybe have it skip to the next cell....is there a way to do this?
ie this:
.86
.53
.78
.96
.45
instead of this:
.86
.53
.78
.96
.45
Bookmarks