I need to make an array formula that compares prod id's from 2 worksheets that are 4 digits long, then takes the value from the neighboring cell...

Hi, I'd like to create a form which includes a "Order Number", so if I print 500 copies and my first page number is say 300, my first copy will be 300, the...

Is there away to hide columns & limit the number of viewers that can unhide the columns (& edit the info) within a protected (read only) Excel spreadsheet.

I want to generate numbers (1 to 15) in cells A1 through O1, but the number in each cells should be unique compare to the other cells, how can I do it? If I...

I have set up a spreadsheet to run a macro and pull data from a DB. This works well but is limited in the fact that is is a snap shot in time and I would like...

Hi, Is it possible to submit the MEDIAN() function as an array (ctrl + shift + enter)? I.e., I would like to submit a function similar to this SUM()...

I can't remember why you would put a $ in a function in a spreadsheet. I removed the $ and it didn't change the number that was there, so why is it needed?

Ok, I currently have the following formula: Code: -------------------- =CONCATENATE(INDIRECT("'Gross%'!A" & (ROW(A28)+32)/6), " ", INDIRECT("'Gross%'!B" &...

Hello from Steved "11-190" is type of vehicle "11-190-12", "11-190-5", "11-190-6", "11-190-7" Can the above be incorporated into the formula...

Hello All, I am trying to test a range of values in a cell: if(and("a1" is 0 to 10, "Jack"), if("a1" is 10001 to 11000, "Jim), if("a1" is 11000 to 12000,...

I'm working on a worksheet with 2 pages. The first worksheet has rows that move to the other worksheet daily. Instead of copying them and pasting them and...

I have created a list box using the multi select function. What I would like to do is be able to highlight multiple items(not in any particular order) in the...

How can I set up 1 cell to search for a specific text, then sum the cell next to it for as many instances of the text? Thanks for any help !

i want to get rid of the #NUM from my cells. Can i use conditional formatting? and what is the formula to...

I have a spreedsheet which we enter data in on a daily basis. At the end of the day I want the last data to go to next sheet. Now I know how to do this but is...

Hi all, I am working on an assignment in my textbookwith a grade book. I've already figured out the test average of 3 tests using the SUM and MIN functions. ...

Function Bahttext and Dollar we got different result. Bahttext our result show in Thai text. however Dollar function show in currency. How to change Dollar...

I am calculating overtime and have a time of 25:28. That is 25 hours and 28 minutes. It is formatted Custom :mm so you actually see the 25:28 in the cell. I...

Hello, is there a formula, which I can use to count the number of formulas on a sheet? Werner Excel XP SP2, WIN XP 5.1 SP1

I HAVE STYLE NUMBERS THAT HAVE UP TO 11 CHARACTERS BUT I NEED TO SEPERATE THEM AS 6 IN THE FIRST FIELD AND THE BALANCE OF 1, 2, 3, 4, OR 5 CHARACTERS IN THE...