|
|
Lock a formula to a column of cells by
dragons_lair
I have a running balance total but as other users access this form they
inadvertently delete the formula or add more rows than have been allowed. I
can use...
|
|
3 |
94 |
|
|
lookup by
amc020781
I use an excel spreadsheet to record numbered boxes that I have in different
locations for different customers. However one customer may have 10 different...
|
|
2 |
140 |
|
|
Conditional Formatting by
Chris 21222222[_2_]
Is there a way to have a list validation that allows the box to change
currencies. For example, if i have a validation stating USD, CAD and I click
USD. And...
|
|
1 |
91 |
|
|
Linking to combo box selection by
PSM
In workbook "A" the user will type lots or data into various pre-defined cells. They will also use a couple of combo boxes to make selections.
In another...
|
|
1 |
86 |
|
|
Vlookup by
Cazumel
I have the following situation:
Look up M1459 on R1459 how do I build my look up reference matching only the
numbers and not the letters.
Thank you
|
May 21st, 2009 12:08 AM
by Max
|
1 |
84 |
|
|
|
|
5 |
198 |
|
|
Sorting data in one sheet by
Gwen
I created a sheet with many columns and rows. I want to be able to sort the
data in different columns but keep all of the row information together. For...
|
|
4 |
107 |
|
|
Conditional Replace without macros by
Craig
Hi
I have a big Excel list with a header row
Right now, I do a filter on two of the columns to display only rows that
meet both criteria. Then I do an...
|
|
2 |
85 |
|
|
Adance Filter that "CONTAINS" by
HeartMom
Hello I need your help. I will warn you now, that I am new here and may not
know the EXACT terminology so please bare with me.
I am trying to use an...
|
|
1 |
90 |
|
|
|
|
1 |
79 |
|
|
Find occurance of a part number? by
Premachine
I have a computer sales program that will output an excel spredsheet that
contans all of my computer generated 10 digit part numbers. Part#'s are
generated...
|
|
1 |
72 |
|
|
Principle and interest formula - Help by
Scoober
Hi,
Can some one help me with the following.
I have had this formula working in a spredsheet for a while now and have
realsied it has a...
|
|
6 |
99 |
|
|
|
May 20th, 2009 08:23 PM
by Lex
|
0 |
104 |
|
|
Merging data from Excel form by
Lex
Is it possible to import data collected using an Excel form into an existing
Excel spreadsheet?
I wish to update an existing Inventory spreadsheet with data...
|
May 20th, 2009 07:59 PM
by Lex
|
0 |
80 |
|
|
date and time format by
sorab
Hi, I'd appreciate a solution if any to my query.
I have entered a date and time in a cell as (9mar09 24:00)
The cell is formatted to show date and time and it...
|
May 20th, 2009 07:49 PM
by sorab
|
2 |
83 |
|
|
calculating days by
Kay
I have a cell with the start date included month, day and year; I have other
columns from january to december. I need to allot 3 day evenly per year that
is...
|
May 20th, 2009 07:19 PM
by Kay
|
2 |
78 |
|
|
I think it is a lookup question??? by
LOC
I have a range of numbers - effect sizes AD2:AD47. In another column AP, I
want write a formula that will look up the percentile conversion within the
same...
|
|
3 |
87 |
|
|
sumif multiple columns by
Mona
Thanks in advance!
Data
A B C D E
1/2/2009 3 1 3 2
1/3/2009 2 5 2 6
1/4/2009 1 3 1 3
If...
|
|
3 |
84 |
|
|
Pivot table help for excel 2003 by
rishi
Hi,
I need to create a pivot table in excel 2003 in the following format
-:
Item SumPrice SumQuantity
A 100 20
B 200 ...
|
|
1 |
79 |
|
|
History of Workbooks opened by
derek
Can someone advise me as to how I can see a list of workbooks I used today
when I open Excel tomorrow. I used to see a list of workbooks I had used when
I...
|
|
1 |
77 |