I'm trying to create a sheet where I have a series of drop down lists where each item on this drop down when selected gives me a grand total. For example,...

Probably very basic question How to randomely distribute non-numerical values across rows (smth like the randbetween() but not for numbers=? For example I have...

i have a payroll grid. it has 3 cells with drop downs that have 39 options. there codes for payments. i need a fourth cell to show a total dollor amount based...

I need some assistance. Here's what I'm trying to do: I have a column with years of service for all our employees, say it's column D. Column E needs to say...

I am working in Excel and out of nowhere my computer will not let me use my arrows to move around from cell to cell? I rebooted and it still does not work. It...

My project involves a random draw for starting order for a sports event. I want to assign a randon number to entry forms, based on a series of numbers from 1...

Hi, I am creating an =concatenate formula from one worksheet to another but need info on individual line, not sentence form. How can I enter a hard...

I have a large number of variables (header columns) in excel that I need duplicated with additional versions (ex: 4) - is there a way to do so automatically...

I currently have multiple rows per client in a worksheet and would like to reduce it to ONE row per client. However, I would like to capture the information...

Is it possible for one cell to calculate two seperate totals based on the calculation in other cells. I've already set the cells below to auto calculate. I...

I should probably preface this with the fact that I'm a total rookie... I just happen to accidentally figure out how to do stuff sometimes, and know "in...

I have numbers in cells like 3054.30, 2997.48 etc. that need to be brought into Word via mailmerge. However, in Word docs the values change to 3054.299999 &...

I have numbers in cells like 3054.30, 2997.48 etc. that need to be brought into Word via mailmerge. However, in Word docs the values change to 3054.299999 &...

Hello In a column I entered dates like 09/27/1958. I then formatted it using mmmm to get month name. In next col. I wanted the month names and hence I copied...

Hello I grouped dates into Months, Qtrs & years, but in the resultant field list I get to see only Years whereas I need the Month field also. What additional...

As given above, I tried the function I get 4 when I use custom cell format as "d", whereas if I don't specify "d" it shows 125. What am I doing wrong? Thanks

I'm fairly new to functions as need help. I have a workeeet that looks like this A B C D 1 Fname Lname ...

downloaded from network report Canadian dates dd/mm/yyyy format and need to convert to US dates mm/dd/yy....

How do you turn off the long references when you linked to Pivot table cell?

Hi, Can anyone suggest me how to hide formulas on a worksheet that is used by several users to update.