|
|
|
|
5 |
93 |
|
|
sort when using VLOOKUP by
Kathie
My sheet has a VLOOKUP set up to fill in name and Biller when client number
is entered. We use this to post checks daily with amount and invoice number.
I...
|
|
1 |
128 |
|
|
|
August 6th, 2008 02:54 PM
by Pete_UK
|
3 |
105 |
|
|
Multiple Vlookup by
Iriemon
I found another post with the following solution to my problem,
unfortunately, I am not understanding how this works.
=INDEX(C1:C100,...
|
August 6th, 2008 02:53 PM
by Iriemon
|
3 |
123 |
|
|
Sort of subsheet by
Pyrite
I know you cannot have subsheets in Excel as it is not a hierarchical system.
I wondered if there was anyway of generating a similar end result though.
I...
|
August 6th, 2008 02:28 PM
by Pete_UK
|
3 |
116 |
|
|
|
August 6th, 2008 02:18 PM
by CAM
|
0 |
136 |
|
|
Lookup or...? by
Lene
Hey, please help an norwegian with a excel-problem..
I have a table where I want to bring back a value from another table (f.ex
weeknr). I have the value...
|
|
3 |
108 |
|
|
|
|
3 |
167 |
|
|
|
August 6th, 2008 01:19 PM
by Pete_UK
|
3 |
136 |
|
|
|
|
3 |
127 |
|
|
Get vaçues in multiple sheets by
Carpe Diem
Hi,
I have a file with 15 sheets, and I need to get 10 type of values each
month accordin one or two conditions. So I use sumproduct to get thios
values for...
|
|
0 |
89 |
|
|
update workbook by
MAANI
Is there a way to update a workbook that has links to other workbooks without
closing the file,reopen it and click update??
|
|
1 |
123 |
|
|
|
|
8 |
148 |
|
|
Automaticcly insert rows by
Tia[_3_]
Hi
I am working on a time sheet each employee has his own sheet to make
his daily data entry till now i have 45 sheets regarding the projects
that they worked...
|
|
0 |
110 |
|
|
Vlook Up by
dcb2
I am having trouble understanding vlookup. Is there a tutorial for this
function? What is the best way to figure it out? I have tried using the help,
but...
|
|
1 |
87 |
|
|
Validation question by
ComicFly
Is there a way to creat a drop down list where each item has a definition,
but when you pick that item only item appears. Example: 03 - Net 30 days ;
04 -...
|
|
3 |
115 |
|
|
|
|
2 |
96 |
|
|
please try this by
driller
First of all, i hope this is easy.
Is it possible *?* to have a subtotal() formula in a column that can count
the cells like;
Formula 1) count the visible...
|
|
6 |
116 |
|
|
|
August 6th, 2008 03:05 AM
by 9274211
|
2 |
97 |
|
|
DP jog macro. by
Aaron
Hey gurus,
I have had a prob for a while and thought I had sussed it but have now
realised im not quite there.
ActiveSheet.Unprotect
...
|
August 6th, 2008 02:54 AM
by Aaron
|
5 |
180 |