Is there some type of fomula where I can copy a cell (preferably a row) if a value is return as true. I'm trying to create a table (from a lager table) that will be based on a cell in that row to be greater than 50. Any help will be great. Thanks!!
Is there some type of fomula where I can copy a cell (preferably a row) if a value is return as true. I'm trying to create a table (from a lager table) that will be based on a cell in that row to be greater than 50. Any help will be great. Thanks!!
Is there anyone who has knowledge of this.
You might investigate VLOOKUP to handle this. It can read the value in the range you set and if it matches your critera, place a designated value in the cell with the formula. You don't give enough details for me to elaborate on. Your table has to be arranged with the lookup values in the first (leftmost) column. It can then read from any designated cell in the row where the value is found.
HTH
Bruce
The older I get, the better I used to be.
USA
okay thanks, i'll give it a try
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks