A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Pivot Table-Running Total by rushdhih
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...
February 4th, 2010 09:14 AM
by rushdhih Go to last post
0 79
Reference shows zero by TommyD
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
February 4th, 2010 08:43 AM
by TommyD Go to last post
5 117
Vlookup across 3 worksheets by Ben
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...
February 4th, 2010 08:40 AM
by Jacob Skaria Go to last post
2 113
Function to lookup date on tab in excel and populate date on calen by MGC
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...
February 4th, 2010 05:48 AM
by MGC Go to last post
0 116
Delete duplicates by Angie M.
Hi, I have a list of numbers that contain lots of duplicates like the following: 133150 133150 133150 133154 133154 133154 133155
February 4th, 2010 04:56 AM
by Ashish Mathur[_2_] Go to last post
4 179
Extract emails from cells with text by AJexcelQuestions
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...
February 4th, 2010 04:47 AM
by Rick Rothstein[_2_] Go to last post
3 101
vlookup issue by Connor Doyle
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...
February 4th, 2010 02:52 AM
by Pete_UK Go to last post
2 82
Hyperlinks not moving with cells when data is sorted by Marina
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...
February 4th, 2010 02:08 AM
by Marina Go to last post
0 82
Duplicate Function Help by akemeny
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...
February 4th, 2010 01:47 AM
by Pete_UK Go to last post
1 85
count cells in a table that meet multiple criteria by Tammy
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,...
February 4th, 2010 01:42 AM
by Pete_UK Go to last post
1 113
How to vlookup and summing value? by Carrie
Hi, please help.... Worksheet name: "Pages" Column A Column B James $100 James $50 AJ $30 Light $46 James $80
February 4th, 2010 12:33 AM
by Ashish Mathur[_2_] Go to last post
4 107
match and sort two different tables by yowzers
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...
February 3rd, 2010 11:47 PM
by yowzers Go to last post
2 142
Formula for adding a cell in multiple workbooks by PaPr
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...
February 3rd, 2010 10:31 PM
by Otto Moehrbach[_2_] Go to last post
1 93
If statement by Donna
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...
February 3rd, 2010 10:24 PM
by Donna Go to last post
3 91
Finding pairs of numbers by Iriemon
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 ...
February 3rd, 2010 10:20 PM
by Iriemon Go to last post
2 130
Column total is wrong by Carolan
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...
February 3rd, 2010 10:17 PM
by T. Valko Go to last post
5 102
Conditional Format Tracker by Date by Dax Arroway
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
February 3rd, 2010 09:14 PM
by Dax Arroway Go to last post
0 84
put a legend in the footer of microsoft office 2003 by legends in footer of microsoft 2003
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...
February 3rd, 2010 08:59 PM
by Gord Dibben Go to last post
1 121
Using paste link by daniesmiley
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...
February 3rd, 2010 08:52 PM
by Bernie Deitrick Go to last post
1 114
VLookup #VALUE! error help needed to resolve by Kristin
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...
February 3rd, 2010 08:50 PM
by Kristin Go to last post
4 117
Post New Thread


Display Options
Showing threads 3281 to 3300 of 87787
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:00 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.