Microsoft Excel Worksheet Functions

Post thread
K
Formular Function
  • Kanmi
Replies
1
Views
318
Teethless mama
T
K
How to VLOOKUP in XCEL across different workbooks each named diffe
  • kool
Replies
4
Views
3K
kool
K
J
SumProduct
  • judith
Replies
3
Views
445
Steve
S
K
Autofill Colour
  • Kanmi
Replies
2
Views
401
Kanmi
K
P
Why is there no Freeze Panes option in the Windows drop-down box?
  • PortNatal
Replies
2
Views
956
Gord Dibben
G
A
Re : How to lock a cell once the value is entered
  • Andy
Replies
2
Views
722
Gord Dibben
G
S
sumproduct issues
  • Steve
Replies
1
Views
532
Steve
S
M
varying a cell and seeing the outcome
  • mikebo
Replies
2
Views
389
mikebo
M
J
Autofill issue
  • Jean
Replies
10
Views
492
Jean
J
O
Time management
  • OKY
Replies
1
Views
403
Luke M
L
C
How to link different worksheets into the 1 menu on a septerate sh
  • cregs
Replies
1
Views
450
Luke M
L
B
Excel "Exact" Function
  • Bryan Gnidrah
Replies
3
Views
4K
T. Valko
T
K
Auto update between two workbooks.
  • Kanmi
Replies
4
Views
636
Kanmi
K
G
Ranking with duplication and gaps
  • Goody
Replies
5
Views
565
Bernie Deitrick
B
F
Validation Data and Looking Up Cells
  • FredK
Replies
1
Views
346
FredK
F
C
Max Value - based on a time period
  • Chris26
Replies
3
Views
512
JoeU2004
J
K
auto update function from workbook to another worksheet
  • Kanmi
Replies
3
Views
413
Kanmi
K
S
Formula to auto calculate based on other variables
  • Scott A
Replies
8
Views
584
Scott A
S
T
formula to lookup data in cell NEXT to another cell
  • TraderXL
Replies
3
Views
433
Ashish Mathur
A
K
Header Row with Option to Shrink/Expand Rows Beneath
  • kippers
Replies
2
Views
1K
Jacob Skaria
J
O
Lookup to return multiple matching values
  • olssonj
Replies
4
Views
1K
olssonj
O
I
Wrong results from MATCH function
  • Imladrian
Replies
3
Views
573
Jacob Skaria
J
J
How do I get the sum of vlookup?
  • jiffy
Replies
3
Views
1K
Jacob Skaria
J
T
Error result for link formula
  • tj
Replies
4
Views
421
tj
T
J
HLookUp function
  • Jbig
Replies
2
Views
429
Jacob Skaria
J
N
Summarising information from different sheets in a summary sheet
  • Naida T
Replies
2
Views
504
Max
M
Y
Pivot table - Change default summarise value field.
  • YY san.
Replies
2
Views
2K
Dave Peterson
D
D
Formula problems that keep producing a #Value! Error!!
  • Danny Boy
Replies
10
Views
608
T. Valko
T
C
over time in a sheet
  • chilson
Replies
2
Views
378
Rick Rothstein
R
N
how can i "transfer data next row every day automatically" in XL
  • Nisar
Replies
1
Views
415
Don Guillett
D
S
custom field with custom formula in pivot table!
  • Sedaghat Nejad
Replies
2
Views
1K
Sedaghat Nejad
S
K
Conditional Formatting - Times
  • kristy_6278
Replies
1
Views
413
Bernard Liengme
B
D
Forecast IF Error Formula
  • Denver
Replies
2
Views
455
Denver
D
R
How would I eliminate the $0.00/column & keep formula
  • Ro1
Replies
1
Views
313
FSt1
F
R
Pasting formats and values without formulas
  • Rae
Replies
2
Views
422
Gord Dibben
G
P
Can LEFT, MID, or RIGHT be used with a COUNTIF or VLOOKUP
  • PJ Murph
Replies
4
Views
1K
PJ Murph
P
A
Count number of cols which contain a value(s) in it less than x(array formula?)
  • AC
Replies
1
Views
704
Lars-Åke Aspelin
L
M
General ledger spreadsheet continued
  • Mark C
Replies
2
Views
701
JoeU2004
J
M
sumproduct with partial charcter matching
  • Matt
Replies
3
Views
847
Max
M
J
Can I use NOT with COUNTIF?
  • JALunceford
Replies
8
Views
488
T. Valko
T
N
lookup same or similar
  • NeedToKnow
Replies
3
Views
476
Keith Faulconer
K
R
Find matching records in two tables using mulitiple criteria
  • RC
Replies
1
Views
592
RC
R
F
Prepending numbers
  • Florian68
Replies
1
Views
391
T. Valko
T
K
Iteration
  • Khalil
Replies
2
Views
437
Khalil
K
W
Conditional Formulas
  • Wendy
Replies
5
Views
384
Wendy
W
C
formula to limit expenses to 1 of 2 values
  • cynomolgous
Replies
3
Views
472
Bernie Deitrick
B
M
#Value in random cells
  • Michael
Replies
3
Views
500
ytayta555
Y
V
COUNTIF calculates slow (10000+ records)
  • VidarHe
Replies
6
Views
9K
ytayta555
Y
M
General ledger spreadsheet
  • Mark C
Replies
3
Views
3K
JoeU2004
J
L
Excel Spreadsheet
  • Lynn
Replies
3
Views
363
Marcelo
M
Back
Top