QUESTION : I’ve been working my head around this, but haven’t figured it out yet, and I’m sure it’s dead […]
Tag: microsoft-excel-2007
Calculation of hour in Excel using [h]:mm formula
QUESTION : START END TOTAL TOTAL 21:00 3:15 6:15 6:15 23:25 1:11 1:46 1:46 20:25 5:20 8:55 8:55 21:25 3:08 […]
Is there a quick way to do a common date-time format in Excel?
QUESTION : Can someone please help me find, built into Excel (any version) a ready-made format for Date/Time like: MM/dd/yyyy […]
Excel method to find the values closest to a given period
QUESTION : I have some data measured at non uniform time intervals, for example: Time(s) Value(KB) 2.1 304 43.0 400 […]
How can I select the whole string except for the first character from a cell in Excel 2007
QUESTION : I have multiple tables where 1 column contains a string which is a combination of a letter and […]
Excel VBA Macro Sub or Function not defined
QUESTION : I used the macro recorder to generate a macro in Excel 2007. When I try to the run […]
Excel MIN with nested IF statement — Trying to ID a date closest to 30 days after a date
QUESTION : I have 16K plus records with an Auction Date. I need to find the date and amount that […]
Excel formula/VBA to detect a property of a group of rows
QUESTION : I have a large dataset in an Excel sheet where: column A: quote number column B: opportunity number […]
Excel 2007 adding a percentage increase
QUESTION : Value = 20 is a constant number Percentage increase to “Value” in levels of 2%, 4%, 5% up […]
Using MAX() in Excel against a list of dates using multiple criteria
QUESTION : I’ve searched and searched and trialled every answer but none seem to work in my situation. Using Excel […]