I have a program done in excel for bowling scores.In one workbook I have 5 different names of bowlers on their own sheet.As i enter each score for each bowler...

Here is the problem.. Waxie Bob Barker (c) (d) (e) (1) 0 12 = Bob barker (2) 15...

Hi Can someone please help me. I am using Excel 2002 and I have about 3,000 #'s (example 4992-5) that I want to find out if any of them are duplicates. What...

I would like to prevent duplicates from being entered. If a duplicate is entered (attempted), a message box will be displayed indicating the row # of the...

Hi there, I am pretty well versed in using Excel, however I have forgotten completely how to do use the lookup function. Can anyone advise what i need to do...

Hi, Novice Excel user here... H5= =IF(AND(ISBLANK(C5),ISBLANK(D5),ISBLANK(E5),ISBLANK(F5)),"$0.00",SUM(C5,D5,E5,F5)) I5=

I have a large worksheet with different formulas in different columns which I want to protect from change but I want to allow others to enter data into...

I have one main worksheet that summarizes the calculations on many other worksheets. I want to have a column that will Edit, Fill, Down like the...

I am stumped on a formula... if ANY one can help me - please post!!! Here is what i am trying to do: Item sells at X Amount If X amount is between $.01 -...

What formula would I use to say: = if , = if , when cells , , and are dollar amounts, and is actually the word "yes" or "no"?

I have an Excel spreadsheet of daily totals where some days have no values and some days have several values. I want to consolidate this into weekly totals....

Hello, I'm trying to get an array formula to work on my WM2003SE pocket pc. Right now if I put the cursor in the edit box and hit CTRL-SHFT and Enter I don't...

I have an invoice & payments tracker for sub-contractors, im trying to create a formula which will allow me to calculate how much each contractor is owed. For...

Hi all Was wondering if somebody could give me some clues on how to insert a drop down list into a cell (if this can be done) This list will contain the...

Hi all Thanks for the info on the drop down lists - has worked perfectly The other thing I want to do is assign a value to the items in the list For...

Hi I've found on this newsgroup a function to get the previous sheet name Function PrevSheet() On Error GoTo EndFunction Application.Volatile True PrevSheet =...

I have an excell sheet that gets updated daily with submissions from different departments, what i want to do is to use a formula to submission by the...

Hi Can anyone please help me compare two columns of text to come up with a list of items that are in both lists Many thanks

I have to make an electronic schedule for nurses which includes both day and nite shifts . I have used the "list" function and it quickly sorts out only the...