|
|
If Then Text Question by
Debi
I have a list of customer numbers and serial numbers. I need a formula that will find the customer number in a list, then fill the cell with the serial number...
|
|
1 |
366 |
|
|
|
|
0 |
498 |
|
|
Excel by
Alzabal
Hi
When I open a Excel spreadsheet, a click to select a cell I highlight multiple cells which I can then trace back to one cell, can anyone please help,...
|
June 14th, 2004 02:15 PM
by Alzabal
|
0 |
364 |
|
|
creating a reservation planning form by
Darren
I have been attempting to create a reservation planning form in excel
that imports Data from an Access database and inserts that information
automaticly into...
|
June 14th, 2004 03:06 PM
by Darren
|
0 |
371 |
|
|
|
|
1 |
1,062 |
|
|
|
June 14th, 2004 03:18 PM
by JML
|
6 |
576 |
|
|
formula to macro by
leeners82
If I have a formula written that I need to put in to excel to create the
macro, how do I paste it and save it so I can run the macro?
---
Message posted from...
|
|
2 |
351 |
|
|
xp wont open .xls file by
Redfred
I have been sent an .xls file on email which my new
computer will not open. Have M/S office installed but
cant open the drat thing. Any help please ??
|
June 14th, 2004 03:53 PM
by redfred
|
5 |
371 |
|
|
Unusually large file by
rekoop
Hello,
I have a workbook that is over 500kb but only contains
about 17kb of text data. When I cut and paste out the
text data the file size remains about the...
|
|
1 |
502 |
|
|
Pivot Table - filtering page fields by
cchristensen
I've set up a pivot table with 2 page fields. Is there a way to make these 2 pull-down menus display only the fields that contain data? For example:
Page...
|
|
1 |
687 |
|
|
|
June 14th, 2004 04:12 PM
by Micos3
|
2 |
578 |
|
|
filling in a column by
Ravi
I have exported data which gives me details of invoices by
client, however the client column is populated just once,
while there can be more than one invoice...
|
|
2 |
319 |
|
|
Formula skipping data by
Joey
Hi
I created a column with this formula to check the data in the other
column.
They all come back positive.
What gets me is that it doesn't pick up all the...
|
|
1 |
440 |
|
|
Lowest 5 numbers in data base column by
riaosu
I am working with a data base where I compute a golf handicap based on
each individual's lowest 5 scores from the last eight rounds played.
The data are...
|
June 14th, 2004 04:27 PM
by riaosu
|
3 |
356 |
|
|
|
|
3 |
318 |
|
|
VB Code to automate a sheet clean-up by
Petitboeuf
Hi all
I am fearly useless when it comes to coding in VB as the code below
will prove :)
Before I give the code I thought I'd share the 'what' I want...
|
|
3 |
579 |
|
|
Comments boxes and grid lines by
Andy
I have recently uploaded a workbook to my website. The spreadsheet has comment boxes that haven't appeared online, I spotted a couple of faded boxes that do...
|
|
1 |
350 |
|
|
Permanent Placement of Comments by
John Gross
Is there any way to permanently move a comment? A comment
that appears at the far right of the screen cuts off any
verbiage that will not fit on the screen. ...
|
|
1 |
493 |
|
|
|
|
3 |
580 |
|
|
count.if by
Giandomenico Rocchi
Is there a way to count the number of cells in a range base on the
format of the cell?
I.e. in a range the number of red cells?
Thanks for any...
|
|
1 |
342 |