I have two columns A = words such as supporter, staff, board B = regsitered, not registered etc I want to count number with two pieces if info - i.e number of...

I am trying to combine the following if functions with an or funtion which will provide mw with the answer 6,10,14,21 or 25. =IF($AG$2="3-6","6", "Not...

Hi I have this formula as a basis: SUMPRODUCT(--(N3:N46="Bob"),--(J3:J46="Apple")) I need to modify the above formula so that it will sum all instances...

I NEED A FUNCTION , MACRO TO NUMBERV AUTOMATICALLY IN COLUMN "A" THE THINGS I WRITE IN COLUMN "B" THANK YOU IN ADVANCE

Hi i have this question asking me to to sum the values in tre row below the scores and divide the by the total points but it's been difficult to solve it...

I want the oldest record to be deleted, not the newest when I find the same customer - how can I ensure this happens?

have data in one cell that shows workers hours by day 04:00-12:30 based on a 7 day work week with days off which would show as "off" or "/" have several...

Hello, I am trying to write paragraphs in excel using wordwrap but I am not sure what to do with the rows and columns. Please help

I have a worksheet, A personalized Address Book that I made with the information I would like to have. I have adjust the cell Sizes accordingly to fit the...

Not sure of correct terms and defiantly a beginner at formula syntax, but for the Guru’s here, this should not be such a hard nut to crack. I have a table...

I have a spread sheet logging production on 3 shifts. I need to automatically draw a line in the sheet every time the shift changes like...

HOW DO I UNLOCK THE EXCEL AND WORD SHEETS SO THAT I CAN TYPE AGAIN -- FLAWLESS

I have 2 sets of numbers in 2 columns A and B example: 1 5 2 8 3 36 4 52 5 10 =MAX(B1:B5)

I want to move older files (excel) to a disc and when I hit save and to where D drive on a disc it say file says read only and won't let me save it. What can...

I need help with a function that will do the following. Based on the level, a specific number of unit will be assigned to that level and the summed . In this...

I have a program that when the information is put into an excel 2003 format it appears as below all in 1 cell. I need to be able to have it all on 1 line to...

I have an excel where in column A i want to create an auto numbering. In column B i have some codes and value No. SO i want to count only the lines that have...

I'm wondering if it's possible to use the advanced filter function to create a range option. Basically, I want to show all data which is between 5% over a...

I am trying to write a formula so that if E17G16andE17H16, red cell fill or red font. Any idea how to do this?