commercial

Hello all, *Second time posting as the last thread did not display correctly* This may be a long shot but I am throwing this out there to see if anyone can help. I would like to recreate a form of a three-structure in Excel. Below is an sample set of folder structure data. Commercial...

I have a list of dates and times that represent when a commercial aired. I have another list with dates and times people called based on the commercial air time. I want to look up the called time based on the commercial aired time. When using the vlookup formula, I used "true" to give me the...

I hope I explain this okay because it's quite complicated but here goes: I have multiple sheets ending with the word "Statistics", Dave Statistics, Stuart Statistics, Alan Statistics etc (more sheets can be added at any given time) I need a formula that will... Firstly look in all sheets that...

OK I have what I believe to be a simple query but I am stumped. Pretty much a beginner user so need some help ok so on sheet 1 I have this table <tbody> Column G Column N Eff Code Eff Multistorey Unit Commercial Retail </tbody> Sheet 2 I have this table <tbody>...

Hi Friends, I wonder whether any formulas available for changing the data based on certain conditions. Example Based on Below Table: If Last 3 Letters in Column B is "mer" and Column A is "9G" then in Column C - it has to give as "SG" else it has to give the same data in Column A. <tbody>...

I am current at a loss and in need of help. Below is the data I am trying to count from. I currently have the count function of: =COUNTIF(G1,"<> 0") in column H. This works if there is a balance in column G. I wanted to take it a step farther and basically if G is zero then if F is "114"...

Hi all, As part of my role as a construction manager I carry out inspections of properties and tender works for them. The type of property (retail, commercial, industrial etc) determines what sort of typical works that will be required. I have a list of typical works to a building which...

I need help to accomplish something with a VLOOKUP command. I have a feeling it involves using some kind of array but am just struggling trying to find a solution. Obviously I am NOT an Excel power user. So if you have an answer for me, please help me understand it with easy explanations. I...

I am trying to use the median function to return a value only when the result of a vlookup is a specific value. I am using the formula = Median(IF(P4:P51="Commercial",C4:C51)) Where column P contains the vlookup resulting in either "Commercial" or "Consumer" and column C contains the loan...