-
Re: Best Formula to Use
Ah my bad. Just stick a 4 in there instead of using the reference and it should get you there.1 · -
Re: Logging In To Multiple Devices concurrently
I don't recommend this. I've tried training groups of people using my personal before issuing them licenses, and it gets weird. Data not saving, crashing, tons of issues. Have you thought of publishi…1 · -
List of date formula I have used repeatedly
Doing this so I have an ongoing list of functioning optimized formulas , keeping it in the community in case it helps someone else. Please feel free to comment with your own, but I'm keeping the most…7 · -
Re: COUNTIFS - Values in Multiple Columns and the Date is this month
You could have a helper in the source that uses a join to concatenate all of the values into a single column, then reference that1 · -
Re: Index / Match / Join Formula across 2 sheets
So there are 2 ways I know to get this result. The first way is similar to what you seem to have tried. Index({Return},match(Join([L 1]@row:[L 2]@row),{search},0) Where you use a helper column in the…1 ·