I have a workbook that contains about 12 spreadsheets. The spreadsheets have this type of formulas (below)all thruout it. I want to copy the workbook and paste it into the new workbook with only the results dipslayed (not formulas).
I could do a paste special and paste in "Values"" only. Then I would have to paste over with "Formats" only. This will take longer then I would like. Is there a faster way?????
{=IF(COUNTIF('Raw Data'!$A$2:$A$2001,LOOKUP(10^10,$A$1:$A3))>=ROWS(B$3:B3),INDEX('Raw Data'!B$2:B$2001,SMALL(IF('Raw Data'!$A$2:$A$2001=LOOKUP(10^10,$A$1:$A3),ROW('Raw Data'!B$2:B$2001)-ROW('Raw Data'!B$2)+1),ROWS(B$3:B3))),"")}
Bookmarks