Forum Discussion
Solved
Help with format formula
Hi. I hope there is a simple solution to my use case. I have an excel sheet where column G, H, J contains numbers, and row 2 cell J2:AB2 contains "priority" e.g 1,2,3,4,5 etc. If G2 is >0 i need...
Let's see if this is what you are looking for. Please see attached demo workbook.
=MAKEARRAY(1,G7,LAMBDA(r,c,"lnnl"))
Martin
Could you provide a sample document without sensitive data or a screenshot for better understanding the requirements?
Thanks
Let's see if this is what you are looking for. Please see attached demo workbook.
=MAKEARRAY(1,G7,LAMBDA(r,c,"lnnl"))
Martin
- That solved it yeas. Thank you 🙂