I have a problem organizing my data into worksheets with consistent variables. I am looking at:
|company name (A1)| Fund Name (B1)| Valuation (C1)|,
however not all companies are in all quarters. Basically, the company name and fund need to be consistent over the 20 worksheets. Is there a way to filter them (through lookup or consolidation) so i can have the same company name and fund name from quarter to quarter and exclude or delete the ones that dont overlap?
|company name (A1)| Fund Name (B1)| Valuation (C1)|,
however not all companies are in all quarters. Basically, the company name and fund need to be consistent over the 20 worksheets. Is there a way to filter them (through lookup or consolidation) so i can have the same company name and fund name from quarter to quarter and exclude or delete the ones that dont overlap?
