Hi all, Trying to group data of a bunch of kids going to lessons by age group, say I've got data as follows, left column being the name of the kids and right...

I am wondering if data from a text box in one worksheet can be linked to a cell in another worksheet. Thank you.

on my worksheet, which anyone can use, how do I deny everyone from entering data on 3 entire columns? these columns contain formulas that deal with the data...

Hi, I would like to make a sample of 50 non-consecutive numbers. But everytime i do a sample, i get duplicate numbers. Could you please tell me a way where I...

Hi, I'm trying to do a simple histogram but Excel seems to ignore the bins I have set up. I have data ranging from 0 through 8. I have bins 0 through 8. Yet...

After i have Subtotaled a spreadsheet, then collapsed to show subtotals can I copy just the subtotal

I am trying to build a model that allows me to move start dates of various projects easily - these projects then feed into a consolidated set of cash flows. I...

I have the need to create a formula that calculates the number of months between cell B3 and C3 then divide that number by the amount in cell A1 then find...

Hello, I have two sheets in a workbook: MasterLog and Site Data. The MasterLog sheet gets updated pretty much every day. Each rowi o this sheet has a...

I am working with a list of names, which includes clients and subsidiaries of those clients, and the subsidiaries names are always slightly different, but...

In Excell 2007, I have a Table defined as "Scores" with Column's Named "Name", "Front", "Back", and "TotalScore". I want to do a VLOOKUP to find the total...

I have multi row, multi column table. I am looking for the min value with the formula below and want the output to be the earliest...

I've got a worksheet in one workbook that I want to paste into a blank worksheet in another. I've tried selecting the whole worksheet, then Copy, etc, tried...

I inherited a spereadsheet and someone changed the cell shading to Gray, I've tried formating pattern and fill color and cannot get it to change back to the...

I use a pivot table for reporting. In the reporting sheet, I use the function to look up in the pivot table:...

I lifted the code below and tweaked from this NG via Gord Dibben (but I've done something wrong as it doesn't do anything) I simply want the date/time that...

How do I convert military time to reg on a spreed sheet?

I want to use conditional formatting to hide or delete rows in Excel if the cells in column A are blank. How can I do this or, if conditional formatting won't...

Given the next example: COLUMN A ROW1 27.35 ROW2 112.01 ROW3 3.75 ROW4 #N/A ROW5 4.55 ROW6 #N/A ROW7

How do I sort worksheets in a workbook based on tab text?