I have a worksheet that I want subtotals for loan amounts for each city.

Other than copying formulas manually to the next row of empty cells, can a function within the preceding data entry cell do the work upon completion, enter,...

Having trouble finding reviews of software that allows you to create reports. using access database.

Dear all, I am a novice to the solver function and would be very appreciative if someone would be able to offer me a solution utilizing solver. I need to...

what does this -- sign do in formulas. -- Nawaz50 ------------------------------------------------------------------------ Nawaz50's Profile:...

I'm sure this is simple, but i suck with excel. Okay, I want to mulitply column A by column B and paste the product into column C. For example, A2 x B2 = C2,...

Hi, I am new to this forum and am trying to explore excel. I want to find the common names between two columns and get the number of the common names. how do i...

I'm entering training dates in Excel. The recertification date is one year from the original date. I want the recert. due date to enter itself when I input...

On some of the excel work sheets I am using I would like to be able to insert an arrow in a cell but can't figure out how to do it. All I want is a simple Up...

Can anyone tell me if macros that are digitally signed would be affected if the person who signed them left a company & their network account...

I've input data with the intention of printing labels, but first how do i set the data to automatically alphabetize.

I was creating a flowchart one night and I highlighted just the flowchart, somehow I was able to hide the cells just inside the highlighted box and I can't for...

I'm brand new to VBA, literally picked up on it a couple minutes ago, it's great so far, but I've ran into confusement. I have a combo box on the spreadsheet,...

I am using this and it works perfectly: =COUNTIF('Issues Registered'!(P:P,"yes") But I want it to look in another column as well (Count "Yes" in column P and...

My AutoFill little black square is not showing up. I already checked to see if it is ON, and it is. Now what; please help me!!! Thank you ~

I am using Excel 2002. I would like to be able to print our timecards for the month on one page. Each timecard fills an entire page. Is there a way to fit...

I have a list of names and an array of numbers to their names. I have sumed the arrays of each name and placed them in accending order using LARGE() function....

Hi all, So this is kind of an unusual request... See, a buddy of mine sent me this EXCEL spreadsheet which - ah, to make a long story short, is a "female...

Dear Sir, I m using this function =IF(AND($A$1="gopal minerals",'Gopal Sales'!E60),'Gopal Sales'!E6,AND($A$1="Micro Products",'Micro Sales'!E60,'Micro...

I want my Excel file to have 2 sheets with 2 tables. I want the 2nd Sheet’s Table to be LINKED to the 1st (so when I update the 1st, the 2nd...