|
|
Summing partial strings. by
[email protected]
For some time now I have been downloading bank statements. I have
columns for Transaction Date, Transaction Details, Amount, Balance, and
one transaction per...
|
|
4 |
89 |
|
|
I don't know if this is even possible... by
Will61768
I want to take a list that has in a column Firstname Lastname and what I
want to do is covert that into Lastname, Firstname.
Is that even possible?
The...
|
|
3 |
117 |
|
|
|
October 8th, 2005 11:54 AM
by colt
|
4 |
146 |
|
|
Need help with formula in Excel XP by
Danchops
I'm trying to create a formula in a cell that, given x, y, and n in
other cells, calculates x*y + (x*y)*y + ((x*y)*y)*y + (((x*y)*y)*y)*y
... n times. Anyone...
|
|
3 |
156 |
|
|
Lotto Number Checker by
clash
Please help.
I have to check 30 Lotto tickets ever week and have tried (and failed)
to come up with a way over putting all the selected tickets in a grid,
and...
|
|
4 |
125 |
|
|
file commands by
mark
When i open an excel file there are no commands or buttons at the top of the
sheet.
This must be a central function as it is the same in all files and...
|
|
1 |
133 |
|
|
Transfers by
[email protected]
Is it possible to transfer a whole worksheet to another so that it is shown
in its entirety at the top of the receiving one and if it is how do I do it?
Thank...
|
|
3 |
133 |
|
|
|
|
1 |
134 |
|
|
|
October 8th, 2005 04:50 PM
by Neil
|
2 |
106 |
|
|
|
|
0 |
248 |
|
|
Highest Score for each Test by
abqhusker
Is there a formula/function to to this? Each student get 3 attempts at
a test and I take the highest score. I want a formula that will display
the highest...
|
|
4 |
120 |
|
|
sum with 2 criteria by
Dave
With the below eqn do the dates have to be a cell reference or is it possible
to use a specific date?
One...
|
|
2 |
130 |
|
|
|
|
1 |
159 |
|
|
|
|
1 |
157 |
|
|
|
October 8th, 2005 08:11 PM
by S2
|
4 |
157 |
|
|
visual basic by
jiwolf
I have a file where one of the worksheets is set to invisible. ( 0 -
xlSheetHidden). how ca I switch it to visible? every time I try to change it
a warning box...
|
October 8th, 2005 09:12 PM
by jiwolf
|
2 |
119 |
|
|
cell text completion by
nospam
Hi,
I am making an index of worksheets tat I use for my pupils.
When I type in some cells excel offers me some text that is in previous
cells in the...
|
|
1 |
104 |
|
|
|
|
1 |
114 |
|
|
vlookup returns column to the left by
Brisbane Rob
I thought this would be easy but still can't get it. How do you get a
vlookup to return a value from a column to the left of the array?
Thanks
--
Brisbane...
|
|
3 |
131 |
|
|
|
|
2 |
131 |