Search results

I am once again looking for talented Excel/Google Sheets gurus to subcontract work out to. I have made 1-2 similar threads over the past few years and added several people to the team, but am looking for new help again since some of the guys I hired in the past either became disinterested or too...

I posted a similar thread back in July, but am once again looking for talented Excel/Google Sheets gurus to subcontract work out to. I have made a couple of similar threads in the past and added several people to the team, but am looking to add some more guys again since some of the guys I hired...

I'm sorry - I misread what you wrote as "did you get MY answers last time". I had a few workable candidates last time but I couldn't work with the quotes they gave me (they were charging more than I charge the clients).

I don't believe I did. Perhaps you could resend your original e-mail?

------------ Description: ------------ I get a fair bit of online work from clients who need spreadsheet work done (typically 85% Google Sheets and 15% Excel), and I lately I've been becoming a bit overwhelmed with orders. Also, sometimes I turn away jobs when they are too large or difficult of...

I replaced my arrayformula with the simple: =IF(B2="Yes", 0, SUM(C1,1)) Thanks to user 'mrhstn' for suggesting that. I never did figure out why Excel was behaving as it was, but this is a far simpler formula and fixes the issue.

I have a table in Excel with an array formula which works, however when I expand the table (add to it), the last row will then change the formula's end range by increasing it to the new range. For example, if the table is currently on row 1055 and the range shows $B$2:B1055, when I press tab or...

Actually it turns out that my original code didn't work because I didn't put the sheet name before "A". I guess the Named Ranges scope determines whether these are required or not!

Thank you Hui. I modified it a bit to include the end date range too, and got it working: =OFFSET('Trigger Log'!$A$1,MATCH('Trigger Log'!$N$1008,'Trigger Log'!$A:$A,0)-1,,MATCH('Trigger Log'!$O$1008,'Trigger Log'!$A:$A,0)-(MATCH('Trigger Log'!$N$1008,'Trigger Log'!$A:$A,0)-1)) I then created...

Hi, I am pulling my hair out on this one. I have a graph in Excel and I want it to update based on two cells I have for the Start Date and End Date. I am using a Named Range for the Axix label range, but get an error when trying to use it ("There's an error in the formula you entered.") The...

Hi, I understand that there is a zero-tolerance policy towards spam, but it appears this is the right spot to post this so I hope it's okay. I get a fair bit of online work from clients who need spreadsheet work done (typically 85% Google Sheets, and 15% Excel), and I find I often have to turn...