|
|
if statements returning dates by
Clinton
i have the following formula to give a 2 day cycle for production which will
skip saturdays and sundays. can it be made to miss other days such as public...
|
|
4 |
103 |
|
|
Time in Excel by
Medic1712
I am trying to do something that seems impossible. I am a paramedic and use
a mobile device during the course of my job. I am trying to write a
spreadsheet...
|
|
3 |
158 |
|
|
|
|
2 |
101 |
|
|
vlookups and if statement by
excelrookie
I am doing a simple vlookup, but need to search another column and if I find
a match change the lookup result.
example
vlookup(a2,tab1a2:b50,3). if A3 = 25,...
|
August 27th, 2008 03:20 AM
by smartin
|
3 |
82 |
|
|
|
|
1 |
113 |
|
|
Sorting information by
CraigMacE
I'm looking for a way to replace a SUMIFS formula to make a worksheet
compatible with older versions of excel. I have a worksheet for data entry 6
columns...
|
August 27th, 2008 02:30 AM
by Max
|
1 |
80 |
|
|
please advise the solution by
Nilesh[_2_]
Hi,
Please could any one suggest how to do the following in excel sheet,
I have two numbers in excel spread sheet
1 is target price
and
2 in cost,
|
|
3 |
77 |
|
|
cell fill by
ldmjr
how do you 'partially' fill a cell with color ?
|
|
5 |
79 |
|
|
Pivot Table Format by
dss[_2_]
I am working in excel 2007. I have created a design for my pivot table. i
want to be able to use this design/format in other spreadsheets. It appear
that...
|
|
0 |
68 |
|
|
Referencing another worksheet by
Carena
What I am trying to do is find a row in sheet 1 that matches my two reference
cells and pulling the information from a specific colume for that row. All I...
|
August 27th, 2008 12:26 AM
by RagDyer
|
2 |
64 |
|
|
Beginning of Year by
Lucy
I'm nowhere near the technical level as most of you on this site, so I'm
hoping you can help me out.
Isn't there a formula you can enter in Excel that will...
|
August 27th, 2008 12:10 AM
by Pete_UK
|
7 |
61 |
|
|
RANDBETWEEN by
Gaurav[_6_]
Hi All,
If I use RANDBETWEEN function to generate random samples, how do I make sure
that units are not repeate?
For example-
I have 1000 units and I have...
|
August 26th, 2008 11:55 PM
by RagDyer
|
3 |
54 |
|
|
|
August 26th, 2008 11:52 PM
by Sheeloo
|
1 |
83 |
|
|
Fill a word form clicking on an excel cell by
Denis
Hi all,
I would like to be able to fill a word form from an excel sheet by clicking
on a cell and transferring the data from the different cells of the row in...
|
|
1 |
79 |
|
|
Drop Down List by
CraigMacE
I have one sheet for data entry where entries include names and dates among
other things. I want to create a second sheet that will search through the
first...
|
|
2 |
203 |
|
|
|
August 26th, 2008 11:04 PM
by RagDyer
|
2 |
83 |
|
|
|
August 26th, 2008 11:04 PM
by zzxxcc
|
2 |
108 |
|
|
|
August 26th, 2008 11:02 PM
by Pete_UK
|
3 |
86 |
|
|
Search for tabs from a cell value by
Alvyn
Dear Sir/Mdm,
Can anyone please advice how to search for a specific worksheet tab based on
a cell value (user input) on a worksheet.
Eg, I have 50...
|
|
7 |
109 |
|
|
Ignore blanks in multiplication formula by
ag10
I've got a column of ten cells that I want multiplied together, i.e.,
=A1*A2*...*A9*A10. A couple of these cells are blank, and I want to ignore
those...
|
|
4 |
85 |