Difficulty 4 of 5 · about 5 min
List invoice numbers over 50,000 in one cell
Invoice references are in A2:A8 and amounts in INR are in C2:C8. In F2, write one formula that returns every invoice reference with an amount greater than 50000, in the order they appear in the sheet, joined into one piece of text with a comma and a space between them (for example INV-A, INV-B).
Loading grid…