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
To list down all SN (Serial Number) by Andri
Dear All, Please help to solve it by FORMULA. I have a database e.g 20 Rows, the fields Product Name, SN, etc (Sheet A) I would like to concatenate the SN,...
September 16th, 2008 04:36 PM
by Andri Go to last post
6 122
Function needed by fgwiii
Good morning, I am trying to identify records in which 'Start Date' is null and/ the 'Unknown or -30 days' field Checked. I tried using a If statement,...
September 16th, 2008 04:28 PM
by Pete_UK Go to last post
3 110
Nested IF too long - other suggestions? by ExchangeNewbie
Our timesheet template asks for the Employee name in a pop-up dialog box. The result assigns a number to a cell. That result assigns the employee name,...
September 16th, 2008 04:26 PM
by RagDyeR Go to last post
7 104
Text Formula by Christopher Naveen[_2_]
Hi, Pls. refer the below mentioned formula. I wanted the Text to Display as "Oct Sales" (means referring to the next month). I tried a lot using this formula...
September 16th, 2008 04:26 PM
by Teethless mama Go to last post
5 106
Financial Numbers not properly adding by BrownsFan
When adding a column of numbers that are formatted as "accounting" and to two decimal places, I'm getting an incorrect total. It's only off by 1 cent, but I...
September 16th, 2008 04:21 PM
by Teethless mama Go to last post
1 98
Average formula limitation by Karen
Does anyone know if there is a limit to the number of cells you can use in an average formula? I'm trying to build an average for weekly number of phone calls...
September 16th, 2008 04:13 PM
by Spiky Go to last post
9 123
Worksheet Total and Macro by RHoskins
The purpose of my Excel workbook is to track vendor PO's that have been sent and acknowledged. I have seven identical worksheets with the only difference...
September 16th, 2008 03:47 PM
by RHoskins Go to last post
0 118
Hyperlink Relative Reference by TKS_Mark
I'm using about 100 3D pdf instruction files that are automatically linked in a spreadsheet. The spreadsheet is small, but the instructions are large. And...
September 16th, 2008 03:41 PM
by TKS_Mark Go to last post
2 150
Condtional formatting in Excel by Eán[_2_]
If I have for example the formula: Formula is =IF(F9-1=$E$6+3,1) which will turn my cell red, is there anyway I can turn it red and mark it with the number 1...
September 16th, 2008 03:08 PM
by David Biddulph Go to last post
1 94
Rounding in Excel by trichey
I am trying to round a cell either up to the nearest 500 or down to the nearest 500...any suggestions. My current formula is =ROUNDUP(A2*1.3,500). Help?
September 16th, 2008 01:25 PM
by Stefi Go to last post
2 84
HEADER and FOOTER by James8309
Hi everyone, I am just trying to insert a horizontal line just below the header and just above the footer. Is this possible? I can do this in Microsoft Word...
September 16th, 2008 12:53 PM
by Dave Peterson Go to last post
3 86
Find and Replace one row only by Nick Wakeham
I am using Excel 2007. How can I carry out a Find and Replace on the one row that I have highlighted? The only options I can find are to Find and Replace...
September 16th, 2008 12:21 PM
by Nick Wakeham Go to last post
2 114
Excel Warning by Esradekan
Could someone please tell me what this warning means? and how i get around it? "The server drafts location you entered for editing is not valid or you do not...
September 16th, 2008 11:46 AM
by Esradekan Go to last post
2 156
Assign a number to a word by Noob McKnownowt
Hello ladies and gentlemen, when i first thought of this idea i didnt think it would be to diffcult to produce, this initial thought has proven wrong :) my...
September 16th, 2008 11:39 AM
by Mike H Go to last post
5 86
Vlookup - maybe?! by Zak
Hi, I want to make use of a vlookup (i think thats what i need!) but not sure how to get it working: I have a drop down list - when user selects something...
September 16th, 2008 11:35 AM
by Zak Go to last post
7 95
HOW DO I CREATE MULTIPLE LISTS by wireman
I need to create lists which comprise data based on a selection from a prior list. Example: Manufacturer list= Vendor1, Vendor2. The next list we will call...
September 16th, 2008 09:34 AM
by VISWANATHAN Go to last post
2 147
Formula to sum up customers totals from other sheets by Steve[_63_]
I am trying to construct a formula which will add to a sheet called "Totals" the amount of parts and labor a person billed to each customer. The customer name...
September 16th, 2008 09:28 AM
by Bob Phillips[_2_] Go to last post
2 102
How to create multiple lists each comprising data from previous li by wireman
First I want to say thank you to Ashish Mathur for his post to my previous question. He answered it in full. I failed to share entire senario. My goal is to...
September 16th, 2008 09:20 AM
by Gav123 Go to last post
1 84
allow a user to edit ranges in a protected worksheet by McA
Hi all. This one has been seen in the past, I run Excel 2003 and have a spreadsheet with 20 worksheets. I want each worksheet to be protected by 1: an...
September 16th, 2008 08:38 AM
by McA Go to last post
3 107
Excel - viewing hidden rows by Brandy
How can you view hidden rows with a "Go To" command? I have hidden rows in a spreadsheet and I want to review a particular row or column by using a "Go To"...
(Multi-page thread 1 2)
September 16th, 2008 08:03 AM
by Stefi Go to last post
11 190
Post New Thread


Display Options
Showing threads 20341 to 20360 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 02:25 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.