Microsoft Excel Worksheet Functions

K
How to VLOOKUP in XCEL across different workbooks each named diffe
  • kool
Replies
4
Views
712K
kool
K
J
SumProduct
  • judith
Replies
3
Views
322K
Steve
S
K
Autofill Colour
  • Kanmi
Replies
2
Views
99K
Kanmi
K
P
Why is there no Freeze Panes option in the Windows drop-down box?
  • PortNatal
Replies
2
Views
373K
Gord Dibben
G
A
Re : How to lock a cell once the value is entered
  • Andy
Replies
2
Views
192K
Gord Dibben
G
S
sumproduct issues
  • Steve
Replies
1
Views
269K
Steve
S
M
varying a cell and seeing the outcome
  • mikebo
Replies
2
Views
133K
mikebo
M
J
Autofill issue
  • Jean
Replies
10
Views
411K
Jean
J
O
Time management
  • OKY
Replies
1
Views
175K
Luke M
L
C
How to link different worksheets into the 1 menu on a septerate sh
  • cregs
Replies
1
Views
51K
Luke M
L
B
Excel "Exact" Function
  • Bryan Gnidrah
Replies
3
Views
183K
T. Valko
T
K
Auto update between two workbooks.
  • Kanmi
Replies
4
Views
349K
Kanmi
K
G
Ranking with duplication and gaps
  • Goody
Replies
5
Views
370K
Bernie Deitrick
B
F
Validation Data and Looking Up Cells
  • FredK
Replies
1
Views
121K
FredK
F
C
Max Value - based on a time period
  • Chris26
Replies
3
Views
189K
JoeU2004
J
K
auto update function from workbook to another worksheet
  • Kanmi
Replies
3
Views
184K
Kanmi
K
S
Formula to auto calculate based on other variables
  • Scott A
Replies
8
Views
754K
Scott A
S
T
formula to lookup data in cell NEXT to another cell
  • TraderXL
Replies
3
Views
173K
Ashish Mathur
A
K
Header Row with Option to Shrink/Expand Rows Beneath
  • kippers
Replies
2
Views
224K
Jacob Skaria
J
O
Lookup to return multiple matching values
  • olssonj
Replies
4
Views
120K
olssonj
O
I
Wrong results from MATCH function
  • Imladrian
Replies
3
Views
260K
Jacob Skaria
J
J
How do I get the sum of vlookup?
  • jiffy
Replies
3
Views
324K
Jacob Skaria
J
T
Error result for link formula
  • tj
Replies
4
Views
440K
tj
T
J
HLookUp function
  • Jbig
Replies
2
Views
126K
Jacob Skaria
J
N
Summarising information from different sheets in a summary sheet
  • Naida T
Replies
2
Views
399K
Max
M
Y
Pivot table - Change default summarise value field.
  • YY san.
Replies
2
Views
157K
Dave Peterson
D
D
Formula problems that keep producing a #Value! Error!!
  • Danny Boy
Replies
10
Views
437K
T. Valko
T
C
over time in a sheet
  • chilson
Replies
2
Views
136K
Rick Rothstein
R
N
how can i "transfer data next row every day automatically" in XL
  • Nisar
Replies
1
Views
200K
Don Guillett
D
S
custom field with custom formula in pivot table!
  • Sedaghat Nejad
Replies
2
Views
288K
Sedaghat Nejad
S
K
Conditional Formatting - Times
  • kristy_6278
Replies
1
Views
208K
Bernard Liengme
B
D
Forecast IF Error Formula
  • Denver
Replies
2
Views
267K
Denver
D
R
How would I eliminate the $0.00/column & keep formula
  • Ro1
Replies
1
Views
188K
FSt1
F
R
Pasting formats and values without formulas
  • Rae
Replies
2
Views
172K
Gord Dibben
G
P
Can LEFT, MID, or RIGHT be used with a COUNTIF or VLOOKUP
  • PJ Murph
Replies
4
Views
134K
PJ Murph
P
A
Count number of cols which contain a value(s) in it less than x(array formula?)
  • AC
Replies
1
Views
209K
Lars-Åke Aspelin
L
M
General ledger spreadsheet continued
  • Mark C
Replies
2
Views
207K
JoeU2004
J
M
sumproduct with partial charcter matching
  • Matt
Replies
3
Views
426K
Max
M
J
Can I use NOT with COUNTIF?
  • JALunceford
Replies
8
Views
467K
T. Valko
T
N
lookup same or similar
  • NeedToKnow
Replies
3
Views
167K
Keith Faulconer
K
R
Find matching records in two tables using mulitiple criteria
  • RC
Replies
1
Views
345K
RC
R
F
Prepending numbers
  • Florian68
Replies
1
Views
163K
T. Valko
T
K
Iteration
  • Khalil
Replies
2
Views
25K
Khalil
K
W
Conditional Formulas
  • Wendy
Replies
5
Views
498K
Wendy
W
C
formula to limit expenses to 1 of 2 values
  • cynomolgous
Replies
3
Views
341K
Bernie Deitrick
B
M
#Value in random cells
  • Michael
Replies
3
Views
232K
ytayta555
Y
V
COUNTIF calculates slow (10000+ records)
  • VidarHe
Replies
6
Views
563K
ytayta555
Y
M
General ledger spreadsheet
  • Mark C
Replies
3
Views
201K
JoeU2004
J
L
Excel Spreadsheet
  • Lynn
Replies
3
Views
79K
Marcelo
M
F
Macro/Formula help
  • fgwiii
Replies
5
Views
223K
Luke M
L
You must log in or register to post here.
Back
Top