![]() ![]() ![]() Now all this works fine, except when I filter the formula column in worksheet 2 to count all the non "Yes" entries the total count is two short of the actual entries in Worksheet 1.Į.g. If it matches it returns the number if not it inserts "Yes" into the cell. In worksheet 2 I have created a column and used the following formula =IFERROR(VLOOKUP(A3,'Security Audit Results - Final'!$C$2:$C$671,1,0),"YES") to check for a number match against the column in Worksheet 1. ![]() In Worksheet 2 I have a longer list of basic numbers (1180 rows). Simple numbers not decimals or anything like that. Worksheet number 1 contains a column list of numbers (670 rows). I am using Excel for Mac V16.43 and have a single workbook with multiple data sheets.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |