|
|
Sums by
Natalie
Hi,
I have a table of data, and want to create a new sheet adding it up -
Part no Qty
670 1
56 6
98 2
670 ...
|
July 21st, 2009 04:42 PM
by Eduardo 
|
1 |
87 |
|
|
Count If Column A = x and Column B = y by
Trish
I am trying to use the count function where two conditions in different
columns need to be satisfied and having no luck. Basically I want to look in
the...
( 1 2 3)
|
|
21 |
357 |
|
|
|
Highlight a row with the current date. by
sword_fishx
Hi, this problem should be easy, but I can't get it to work
Colum A10 as a date, with the month and year for the next two years listed.
I have the current...
( 1 2)
|
|
11 |
182 |
|
|
|
format number to date by
Picodillo
When I run a query from work and post the information in Excel, the date
shows an odd format. For instance, for July 20, 2009, the date would read
1090720. ...
|
|
8 |
111 |
|
|
|
Micro by
Ganesh Kumar
Please Tell Me About The Macros that How to Run it
|
|
2 |
129 |
|
|
|
Counting Column by
Cul
I am trying to get a count of how many items in a spreadsheet I have an
example below. Basically if the number is listed more than once then it is a
part to...
|
|
3 |
100 |
|
|
|
Formula for calculator Table by
Sky[_3_]
Hi,
Could anyone help me.
I had a table on some rate as per below shown.
If I entered 100 it will auto take 100*0.27*1.45=39.15 as formula
Airport Dest...
|
|
8 |
165 |
|
|
|
Selecting rows within a range by
JCG
Greetings:
I'm developing a macro that will select all project numbers for an
individual in our organization. I hope to have a program/function that will...
|
|
5 |
101 |
|
|
|
|
July 21st, 2009 02:25 PM
by Max
|
7 |
197 |
|
|
|
auto scrol doune for hyperlink. by
rajaiy
Dears,
I have one excel sheet, I need to make auto scrol doun fore the hyperlink,
like this example,
a1 = 419 b1= \\appserver\users\FILE 02-\419.xls.
so...
|
|
2 |
114 |
|
|
|
|
|
0 |
116 |
|
|
|
Why doesn't it print the colours? by
EN
I've a worksheet with an invoice template. There's a logo in colour but it
always prints in black and white. Can anyone tell me why and what to do about
it?...
|
July 21st, 2009 07:53 AM
by EN
|
8 |
117 |
|
|
|
Formula not updating by
nzcass
Excel 2003
If I change a number that is part of a group that is in a formula (ex: two
numbers being multiplied with a total at the bottom) for some reason...
|
|
1 |
123 |
|
|
|
using the Cell function by
WT
I am able to aquire the name of a page with the following equasion.
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255).
And I have found that I can...
|
|
2 |
114 |
|
|
|
Lookup dates and values by
Suan
Hi
I want to set up a formula that allows me to enter a date on spreadsheet
A(eg May-09) and in Spreadsheet A also have a month actual column for various...
|
July 21st, 2009 03:25 AM
by Max
|
5 |
132 |
|
|
|
Showing the entire text within a cell. by
lehigh46
Hi ALL,
I copied and pasted about 600 items from a CSV file into a blank Excel
sheet Ver 2007.
Aprox 10 % of the cells did NOT show all of the text.
I...
|
July 21st, 2009 01:03 AM
by Bam
|
1 |
114 |
|
|
|
|
|
11 |
177 |
|
|
|
'Smart worksheet' by
Lorraine.vdWalt
This is probably quite basic really but it's really got me - i'm stuck.
I want to update by personal budgeting spreadsheet so that i have less
updating and...
|
July 21st, 2009 12:24 AM
by RagDyer
|
1 |
113 |
|
|
|
Identifying correct elements with Countif by
Lady Success
I’m trying to count the number of instances a specific entry appears and then
I want to display the instances it found in the database. My logic for the...
|
|
3 |
109 |
|
|
|
Cell preservation or previous value. by
Paul
Is there a function that will allow you to maintain the current value of
a cell or retrieve the previous value of a cell? Consider the following...
|
July 20th, 2009 09:51 PM
by Paul
|
0 |
89 |
