match0

Hi All, I hope someone here can help me out. I've been searching everywhere and cannot find what I need. To explain, I am working on a workbook that has a table within it that contains load of rows of data. This table is called TeamSheetsAll. Within that table are many columns, but relevant...

I have the following formula's which sort of work fine (shown below) to transpose the data in the first table below, except if the ID value (in column A) is the same value as the result (in column C) So if C2 was changed to 8, it would ignore it and then mess up all the other figures for that...

Hi, I'm having difficulty getting a formula to work that I found here. I want to list all unique entries from a multi-column array on one worksheet to a different worksheet, as a single column of data. VBA or formula solutions are ok. This is the worksheet formula that I'm trying to get...

Hi Guys, I am having real trouble getting the second criteria in to my formula. Effectively I want to do the following (which works): Return list of unique values in K where N1 appears in column E. =IFERROR(INDEX($K$2:$K$3000, MATCH(0, IF($N$1=$E$2:$E$3000, COUNTIF($O$1:$O1, $K$2:$K$3000)...