Hi,
I've been searching for 3 days now for the below requirement but couldn't find an answer. i tried combining multiple VLOOKUP formulas but no luck.
i have big data below that is used to forecast when a server will reach memory consumption of 70%
B1 to IC1 list of Server names. A2 to A330 are dates (5/15/2019 to 2/20/2020). B2 to IC330 are 2 digit numbers, increasing from 33-99 where it tells when a server will reach 70% on specific date.
i want to collect only those cells with value of 70 and return with it the date from column A <same row> and Server name from the top header <same column>
is this possible?? please help....
I've been searching for 3 days now for the below requirement but couldn't find an answer. i tried combining multiple VLOOKUP formulas but no luck.
i have big data below that is used to forecast when a server will reach memory consumption of 70%
B1 to IC1 list of Server names. A2 to A330 are dates (5/15/2019 to 2/20/2020). B2 to IC330 are 2 digit numbers, increasing from 33-99 where it tells when a server will reach 70% on specific date.
i want to collect only those cells with value of 70 and return with it the date from column A <same row> and Server name from the top header <same column>
is this possible?? please help....