Browse categories
Explore
Fiverr Pro
English
$
USD
I will write an array formula to replace your nonarray formula
About this Gig
I am an expert of decades. I solve the hard stuff.
Individual drag-down formulas are hard to manage, require manual work, invite human error, and are a nightmare to edit. More importantlythe slow down a spreadsheet.
In most cases, a single array formula can quickly do the job of an entire row, column or block of individual formulas.
Share your file URL with me. Once I have access, I will
confirm the goal before you pay. Follow with a separate email with your name
and the spreadsheet title. If you're not sure how to do that, email me and I'll
walk you through it.
The spreadsheet must contain
your currently working, error-free individual formula that you want replaced
with one array formula. Be clear about the sheet and range where that formula
is in your spreadsheet.
I will ask any further
clarifying questions if needed, within reason.
I will replace your many individual
formulas with a single array formula that returns the same results.
Changes to the data, layout,
conditions or expected return after I begin will constitute a new project.
Let's get this solved.
Platform:
Google Sheets
Development technology:
Other
Expertise:
Formatting
•
Fixing
•
Formulas
•
Functions
•
Other
Other Data Processing Services I Offer
FAQ
Why should I use an array formula instead of individual formulas?
Most importantly, it increases efficiency while decreasing manual work and potential for erasing important formulas. (See gig details for more.)
What if I need to change the data, ranges or expect results after you start?
That would constitute a new problem. I will finish writing the formula as it was presented to me. Then we can work something out for changes or additional specs afterward.
What counts as an included "tweak" to a formula?
A "tweak" means that after testing the formula and within 24 hours of completion, you find a case that was included in the original "expected results" but which the formula fails to handle. This is rare (I've been at this a long time) and should require only a few minutes to make any such change.
What if you can't write an array formula equivalent of my individual formula?
Share your spreadsheet with me (see description above) before you book. I will confirm whether or not an array formula replacement can be written. An array formula can be written in the vast majority of cases. I have never said I could do something and then not delivered what I promised.
