Start Time End Time TimeTaken ActualTime Break Start Break End Total Break 14:33:49 14:34:12 00:00:23 X 14:33:51 14:33:54 0:00:03 14:36:07 ...

I'm looking at 100 companies and have their p/e ratios in column B. I want to identify the percentile of each p/e ratio in the group and extract the bottom...

I learned a bit from JLathman in a previous post but tried to use the same methodology with this formula (also learned from this Group to get the last...

Hi, I am wanting to concatenate a set of text to create a formula. I have done so below. =CONCATENATE("=MAX('",O1,"'!A3:A65536)") The result is: ...

I have column A ranging from (Seq)1 - 30 with numerica value. Column B with (Description)Text names. The data is to be linked so that whenever the seq...

Hi - I have a column of cells that is fixed length but the entries within it are not fixed, some columns might have more or less entries than another column....

I have a fixed row of 7 cells, any one of which might contain a number. the cell with the number is the relevant one and it will determine my formula; i will...

The data refresh is causing a not responding message. Exel closing down. There are 40 web links It is a 2007 spreadsheet Created 4 new links in clean sheet...

Hi....in sheet 1, I have a column that has unique numbers and using the following formula to lookup the field in sheet 46500! Column H and then count the...

My data has following structu A09 (code) and B09(time) are headings of a table, its data is filled from A10 upto B100 or so. A column contains codes which...

Is there a way to exclude counting values in a total when rows are hidden and including them when they are not hidden in a COUNT, COUNTIF, and COUNTA...

I have an attendance sheet that 1 day per week. I want to extend a series across the top row. (I.E. Jan 1, Jan 8, Jan 15, Jan 22, etc.). The sheets are...

Good Morning & a Happy New Year to all subscribers in this group. I want to round up Start times and round down Finish times to the next or previous 15...

I'm working on a home budget, and I've made 26 sheets (labeled 1-26, aptly). Each of the sheets calls the previous information from the other sheets, and if...

Worksheet #1 - Standing Database of inventory Column A = Kool, Marlboro, Newport, Snickers, M&M, Miller, Bud, Labatts (Actual data is product number) Column...

Good afternoon -- I built a workbook used to calculate medical fees and productivity. It's based on several reference lookups, and lots of internal...

I have an Excel spreadsheet (.xlsx) that I want to use to determine correlation. There are 30 columns and 690 rows (1 row of “Labels�, and 689 rows of...

Can someone provide some insight into why Excel will always return TRUE when, for example, we have ="a"27 (or any other number) and FALSE when ="a"27?

Is it possible to have a sum in a Vlookup?

I am trying to create a formula that will automatically sum the last twelve months of data when new months are added (in columns) to the right of the most...