|
|
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
|
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
|
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
|
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...
|
|
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...
|
|
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
|
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
|
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
|
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...
|
|
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
|
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...
|
|
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...
|
|
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...
|
|
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
|
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
|
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...
|
|
2 |
147 |
|
|
|
|
2 |
102 |
|
|
|
September 16th, 2008 09:20 AM
by Gav123
|
1 |
84 |
|
|
|
September 16th, 2008 08:38 AM
by McA
|
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"...
( 1 2)
|
September 16th, 2008 08:03 AM
by Stefi
|
11 |
190 |