lot of VLOOKUP, IF, IFS made too slow.
a excel file, having 40 sheets, 400 rows in every sheet, containing at least 400 VLOOKUP, IF, IFS.
this makes the file too slow while editing single record. any solution for the same.
a excel file, having 40 sheets, 400 rows in every sheet, containing at least 400 VLOOKUP, IF, IFS.this makes the file too slow while editing single record. any solution for the same. Read More