Forum Discussion
repeating IFS formula on different data sets in false
Hi, my spread sheet is 5 columns by 30,000 of raw data. I am using the IFS function in column 6. If my IFS function remains false using data from cell A1 and cells A2 to A5, I want to repeat the sam...
This is very do-able with a LAMBDA (If you're on 365). If you're able to upload a sample workbook, you'll likely get a few excellent solutions to pick from.