-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
let function
-
R
Spill array that only shows rows that have value in certain cells
I have a lengthy process that ends in a dynamic, single cell spill array (shown below). This array currently reports all records from a data table. However, I would like to exclude rows where certain cells are blank. I'm feeling like =FILTER() is the right tool, I'm just not able to configure it...- realtoast
- Thread
- filter function let function spill array
- Replies: 1
- Forum: Excel Questions
-
B
Return different quantities of question types from a randarray.
Good morning, This is a continuation from a previous question (found here). I do however now have another question about adding a feature to the sheet. Do you know if it is possible to select 'x' amount of questions from User Group 1, 'y' amount of questions from User Group 2, 'z' amount of...- baileyb103
- Thread
- let function question bank randarray test
- Replies: 2
- Forum: Excel Questions
-
P
XLOOKUP will not allow to lookup the entire column. For Google Sheets.
Dear Excel Experts, I have a below formula whereby it returns the name with the closest date from today's date. =LET(f,FILTER(I2:I18,E2:E18=R2),XLOOKUP(TODAY(),P2:P18,f,XLOOKUP(TODAY(),P2:P18,f,,-1),1)) While the formula works fine when the range is set with specific rows, when I set the...- Pupishi
- Thread
- let function xlookup
- Replies: 7
- Forum: General Discussion & Other Applications
-
Using LET Function inside HYPERLINK Function
Hi Experts I was using following formula, which was working fine. =HYPERLINK("#"& IFERROR((IFS(DAY(TODAY())<=2, ADDRESS(MATCH(1,INDEX((Banks[Dt]>=EOMONTH(TODAY(),-1))*(Banks[Acc]="CC ICICI SGM")*(Banks[Particulars]="Payment"),0,1),0)+5,COLUMN(Banks[Dt]),4,1), TRUE...- SanjayGMusafir
- Thread
- hyperlink function let function
- Replies: 2
- Forum: Excel Questions
