Showing posts from October, 2023Show all
INDEX function together with MATCH function Advanced Use

INDEX function together with MATCH function Advanced Use

shekhnasim October 20, 2023

INDEX function together with MATCH function Advanced Use Did you ever fill that you need a formula that lookup with r…

Read more
INDEX function together with MATCH function

INDEX function together with MATCH function

shekhnasim October 19, 2023

INDEX function together with MATCH function Formula Description : MATCH(F2, C:C, 0) : The MATCH function searches for…

Read more
Combination of IFERROR and VLOOKUP formula

Combination of IFERROR and VLOOKUP formula

shekhnasim October 16, 2023

Combination of IFERROR and VLOOKUP formula in Excel =IFERROR(VLOOKUP(H2,A:B,2,0),VLOOKUP(H2,D:E,2,0)) The formula we&#…

Read more
Count the number of distinct/unique items

Count the number of distinct/unique items

shekhnasim October 15, 2023

How to count the number of Distinct/Unique items in Excel? While working with Excel big data, we may look for solution…

Read more
Load More That is All