Hey guys - I am just learning that sometimes excel can't handle something and you may need some code - but am curious if there is a solution to this. If you have 4 columns of text based data and want a list of the content of the first column for rows filling certain criteria in the other three columns what function would you use?
In the real situation there are over 1000 rows of which only 5 meet the critreria for a given search and what I want is that list of 5 items on the first 5 rows of the resulting list - not spread out over 1000 rows. Using the standard "IF" format doesn't do this for me.
Any suggestions / guidance would be appreciated - sorry if this has been addressed previoulsy - I have not gone into the forum history.
In the real situation there are over 1000 rows of which only 5 meet the critreria for a given search and what I want is that list of 5 items on the first 5 rows of the resulting list - not spread out over 1000 rows. Using the standard "IF" format doesn't do this for me.
Any suggestions / guidance would be appreciated - sorry if this has been addressed previoulsy - I have not gone into the forum history.