I have a table that list names,club and stats for sporting competition. My problem is the stats are recieved with the name as - A.Name as there are...

I am analyzing data from a measure with two scales. There are 8 total questions in each measure. Answers from Respondent #1 will in column 1 in excel (rows a1...

Is there any way to have pre-formatted controls and form items (drop-down and check boxes) appear when a certain value is input into a cell? What I am trying...

I have a workbook with 4 sheets. Sheet 1 Column A allows users to enter a location name Sheet 2 Column B automatically creates a dynamic drop-down of the...

Is there a way (preferably not with VBA) to assign a date to a new record when a cell is a certain value? In this instance, when a particular cell shows...

I want to add the cells in column D, when their corresponding column A is a specific label. For example, Column A Column D Blue ...

I assigned a recorded macro to an object. When clicked it sorts range A12:A2500. It works fine until I turn on sheet protection. The range is not...

Hi, Is there a function or formula to automatically insert a new line in Excel. In this instance, I have a spreadsheet with three sections (top to bottom). ...

i posted this previously but got lost in between other questions so here it is again. i need to convert matrix looking spreadsheet to a normalised table so i...

When I run subtotals on a set of data, it's obviously not that flexible in what it will display for the subtotals themselves. For instance, I have a three...

Hi, I work for a small construction company and I am working on a material list for jobs. What I need is a function that will go through the list and remove...

When I insert or delete cells a paintbrush box shows up covering most of the cell below. How do I get rid of the paintbrush forever?

I have consecutive dates in column B and integers in column D. In column B, there can be anywhere from 0 to 10 dates listed and in column D, there may or may...

Hello Group i have this rather simple equation , but cant seem to figure out how to write it in excel x1=x2=x3=x4=x5=x6=x7=x8=x9=x10 These are just initial...

Hello Group I am resending this..i dont know why this post did not show up. Anyways,i have this rather simple equation , but cant seem to figure out how to...

I have a workbook w/three different worksheets. They all contain a column that has employee IDs each with the same heading. So the columns match, they just...

I have a workbook which has quite a few worksheets. I'd like to have a table of contents which lists each worksheet but does not necessarily have to link to...

Limited excel formula knowledge. Trying to create a formula based on a dollar amount input to give you a specific output. I'm trying to use this in a self...

EXCEL - Can anybody show me the specific keystrokes to direct a cell to be a certain color pattern based on the following example? If the entered data in B1...

I work on bank reconciliations and the tabs say "7-19", "7-18" etc. Figured out how to auto copy the tab data but how can I add to it so it reads "7-19-06"? ...