Last seen: May 22, 2025
I think you'd just use an XY scatter chart and add a dummy series to label the vertical axis. See attached example.
You could check to see if the sheets already exist like this: Sub test() Dim template As Range Dim tabblad As Worksheet Set tabblad = ThisW...
Are the sites always in the same order as in your example? I'd suggest using a couple of helper columns and a helper row to avoid repeated loo...
This part: ((acuriteweather[Date]=D5)*(acuriteweather[Outdoor Temperature]=G5)) creates an array of 1s and 0s. Multiplying by the time stamp ret...
If you mean the password to open the file, simply open it (supplying the password) then select File - Protect Workbook, Encrypt with password and clea...
What exactly is the issue? If it's just getting them on the same row, set the pivot table layout to tabular.
You can also fix it by not clearing cells that are actually empty (which is after all fairly pointless) by making a small change to the condition: ...
For your max temp time: =AGGREGATE(15,6,1/1/((acuriteweather[Date]=D5)*(acuriteweather[Outdoor Temperature]=E5))*acuriteweather[Timestamp],1) Fo...
Hi Anders, You are correct. It’s force of habit I think that made me write 1E100! In truth, you could either use: =IFERROR(LOOKUP(1E+100,SE...
You could also use LOOKUP like this: =IFERROR(LOOKUP(1E+100,1/SEARCH(list,A2),list),"No match")
Purely for information, you could also write that like this: =G2*IF(OR(C2={"Service Fee","Credit"}),8%,4%)
You're welcome.
You will need to put the green condition first - I should have mentioned that.
On which line? You will need to amend Combobox2 in the code to whatever the name of the second combobox is of course.
You might set up a third condition for >500 and <=700 and colour it green for example?