Hello, I have created a Project Finance Reporting Tool, which is based on Pivot Table. The Source data has several fields in addition to the ones below. I...

Hi, I have a cell reference in cell B1 (=A1). If A1 is empty B1 shows "0". Why isn't B1 empty if A1 is? Both cells have format General. /Tommy

Hi, I know there are probably a 100 answer's already posted about this but I can't get one to match. I have a Vlookup formula that i can get to work looking...

I have created a workbook with a tab for each month. These tabs have various columns with dates (move in date-column C) followed by columns for a follow-up...

Hi, I have a list of numbers that contain lots of duplicates like the following: 133150 133150 133150 133154 133154 133154 133155

I have a row in column A which includes an email address in the text that I'd like to extract to column B. Is there a formula I can use to accomplish...

Folks, Sorry if I'm phrasing this wrong, but I've got a vlookup issue that is returning me N/A values. Here goes: The lookup value is a cell which contains...

I have a spreadsheet where I have included hyperlinks. When I sort the data or add new rows, the hyperlinks are NOT moving to the new destination of the...

I'm trying to use a duplicate function (or possibly a duplicate macro) to filter through information. I've tried =countif($A$1:$A$2000,a2) to locate which...

I have a table that I want to set up formulas on a separate sheet for cells to be counted that must meet several criteria. My table does have blank cells,...

Hi, please help.... Worksheet name: "Pages" Column A Column B James $100 James $50 AJ $30 Light $46 James $80

Column A has customer name, columns B,C,D has corresponding sales data for that month. Column E is blank. Column F has has customer name. Column G,H,I has...

I want to add a cell from 52 different workbooks into another "Year End" workbook. Is there a formula that makes this easier than having to open all 52...

I need a formula that will help me produce the correct answer in this scenario: If Revised forecast is 0 then Forecast - Actual, if Revised Forecast is 0...

Is this possible? I assume this will involve some VB coding also: Part Num Associated Part Num 123 456 789 5623 8521 6352 456 123 5478 9821 444444 ...

I have a column of figures which is the result of multiplied column A x Column B. Column B is a multiplier of .001665. The result is shown to two decimal...

I'm building a tracker to make sure paperwork is done on time. Headers: A:Name B:IDNum C:Phone D:StartDate E:Plan F:Paperwork G:30DAuth H:90DAuth

I have an excel spreadsheet that i need to put a color key code or a legend in and i tried to change the font to wingdings but it is not working for me. So...

I'm tyring to sort out a spreadsheet that was previously made by someone else that I'm required to use. The parent spreadsheet that has collaberated info...

The following is the funcation I have: =VLOOKUP(B10,'FA CC Summary Report 1141'!F$9:G$92,2,0) I have all the columns formatted the same; as in the column that...