Top Questions

1. Perform different VLOOKUPs based on value of =RIGHT value
   3 votes

   2 answers
2. Pull every nth group of rows spilled from a single cell
   3 votes

   1 answers
3. Cross comparison of duplicates in multiple columns using COUNTIF / SUMPRODUCT
   2 votes

   1 answers
4. How to automate split by delimiter in Excel (equivalent of =SPLIT in gSheets)
   2 votes

   1 answers
5. Is there a way to find the closest row match based on a different row match?
   1 votes

   2 answers