|
|
|
|
1 |
128 |
|
|
Scroll tabs by
Engineer Mark
In very large spreadsheets I often want to scroll down to a specific row
multiple times. Does Excel have anything similar to a tab or marker that you
could...
|
|
3 |
139 |
|
|
|
|
3 |
119 |
|
|
using "OR" by
Bklynhyc
Hi,
Would like to get some advice on function OR
I have two column both returning information TRUE or FALSE,
It looks like this
TRUE FALSE
TRUE TRUE
|
October 28th, 2009 08:55 PM
by Mike H
|
4 |
101 |
|
|
Reminder by
Bernard Liengme[_2_]
Hi Tim,
Furniture pick up at Sears please
Tkx
Dad
|
|
2 |
116 |
|
|
|
|
6 |
108 |
|
|
Count the number of workday in a month by
YY san.[_2_]
Hi,
Pardon me if I have already posted this question, because I cant locate my
question anywhere. I guess, it is not saved.
I know I need to use NETWORKDAYS,...
|
|
5 |
148 |
|
|
|
|
4 |
214 |
|
|
vlook up by
CandiC
The following calculation is in column D9, this is stating to look at the
Customer account # entered into Column D3 by the user and perform the
calculations...
|
October 28th, 2009 07:43 PM
by CandiC
|
0 |
95 |
|
|
Need to use Countifs to return unique data by
ascottbag-hcm
I am using Excel 2007. In the example below I need to return a count of "2"
for each of the unique data elements in column "B" based on the values in
column...
|
October 28th, 2009 07:22 PM
by Mike H
|
1 |
155 |
|
|
|
|
5 |
163 |
|
|
non number consolidation by
Jason Sands
Hello group. I have attempted to consolidate fields with no luck. The
first field column I have changed to Store, so I can insert it into my
address book. The...
|
October 28th, 2009 06:44 PM
by Pete_UK
|
1 |
91 |
|
|
Searching for products and categorizing. by
Nicholas1
I've got a tricky one, well for me anyway.
I need to classify a list of products into Hardware and Software. The
trouble is the items can be called Licensed...
|
October 28th, 2009 04:44 PM
by Pete_UK
|
2 |
131 |
|
|
Extract characters from cell by
Juan Marin
Good morning everyone,
I would really appreciate if somebody could give me a hand with this:
I'm trying to extract the state for each one of my cells on the...
|
October 28th, 2009 04:40 PM
by Pete_UK
|
2 |
107 |
|
|
Insert date, but keep static on archived by
paankadu
How do I get the date to remain static when a sheet is saved and not change
to the current date when it is re opened. It is a daily log and each shift
it...
|
|
4 |
137 |
|
|
Excel TRANSPOSE by
lolita
Does anyone know how to take 7 rows/20 columns and place into a single column
as the example I have here???? This information is uploaded into our
database...
|
October 28th, 2009 03:31 PM
by lolita
|
0 |
103 |
|
|
|
|
1 |
97 |
|
|
Count If by
Eán[_2_]
How do I write a formula that will return a '1' if an adjoining cells
contains a value between 1 - 7?
Help please - many thanks.
|
|
4 |
102 |
|
|
Dynamic drop down list by
Bala
Hi,
I have two columns A and B as shown below. When I choose North in Col A, I
should get only values correspondig to North in Col B . ( 1,4,2 and 6). Can...
|
October 28th, 2009 12:00 PM
by Eduardo
|
2 |
93 |
|
|
|
|
2 |
86 |