Microsoft Excel Worksheet Functions

Post thread
L
Offset/Match Double Lookup
  • LCW
Replies
4
Views
2K
LCW
L
M
What function to use? Len?
  • mklafert
Replies
11
Views
890
Max
M
D
Worksheets
  • Donna
Replies
1
Views
359
Dave Peterson
D
C
obtaining data from a table
  • Chau
Replies
1
Views
307
Fred Smith
F
C
obtaining data in text form from a table
  • Chau
Replies
1
Views
353
Fred Smith
F
S
Instructions on how to use macros
  • Sophie
Replies
1
Views
389
John
J
B
Hiding/Unhiding Rows Automatically
  • Brad Resnick
Replies
1
Views
720
Don Guillett
D
C
Last value in column before blank
  • craig
Replies
10
Views
739
T. Valko
T
M
moving row data to a colunm in sorted order
  • moving row data to a column in a sorted
Replies
9
Views
654
Max
M
R
counting cells
  • rbwn54
Replies
3
Views
282
T. Valko
T
D
Adding values that fall between 2 dates
  • Dwells
Replies
3
Views
472
T. Valko
T
R
SUMIF Help
  • RLock13
Replies
1
Views
349
T. Valko
T
M
Copy formulas from one workbook to another
  • Ming
Replies
1
Views
545
tech1NJ
T
K
counting the number of times shown
  • klh84
Replies
3
Views
369
Gary''s Student
G
J
Can these look ups be done using Worksheets functions
  • Jan Kronsell
Replies
6
Views
583
Bernie Deitrick
B
W
Use of "AND"
  • Wally
Replies
2
Views
270
Pete_UK
P
G
How do I round Up to the nearest hundred?
  • Guest
Replies
8
Views
2K
Glenn
G
T
rounding up to the nearest 1000
  • tonia
Replies
1
Views
812
Mike H
M
I
Division of all cells by a common number
  • Icegirl
Replies
3
Views
553
Otto Moehrbach
O
G
Conditional Formatting - Thick Border?
  • Guest
Replies
6
Views
10K
RabidExcel
R
P
Sum If - 2 conditions
  • penguin77
Replies
2
Views
445
JLatham
J
T
how to undo scrolling tied to a single cell
  • Tom
Replies
1
Views
610
JLatham
J
S
Counting the lack of a union of two lists
  • Skippy Howenstein
Replies
2
Views
428
Rick Rothstein
R
W
How to run an event upon changing the value of a specific cell?
  • Wael Fathy
Replies
1
Views
394
Luke M
L
R
How can I SUMIF between rows rather than columns?
  • Robnarc
Replies
2
Views
754
Bernard Liengme
B
H
If formula
  • Horacio
Replies
4
Views
386
Horacio
H
R
percentage of green cells in list
  • rslc
Replies
3
Views
10K
rslc
R
B
Countif Limitations
  • Booey
Replies
4
Views
5K
Bernd P
B
P
My Excel operates as if Ctrl is always depressed. Help!
  • parsochr
Replies
1
Views
448
Bob Bridges
B
M
what's the difference between NPV and XNPV ?
  • mr.a.saif
Replies
0
Views
3K
mr.a.saif
M
T
functions quit working
  • Toby John
Replies
1
Views
353
Fred Smith
F
S
If data present, then display graph.
  • Solomon
Replies
2
Views
372
Ashish Mathur
A
P
Counting NON-Blank fields
  • Phyllsf
Replies
2
Views
1K
tompl
T
D
v look up
  • Donna
Replies
1
Views
466
Donna
D
K
Excel "IF" functions
  • Katrina
Replies
1
Views
304
Fred Smith
F
C
Sum with multiple conditions
  • Curtis
Replies
6
Views
641
Max
M
C
How do I use Excel to convert feet to kilometers?
  • CedarHillMatt
Replies
3
Views
668
FSt1
F
A
Insert a semicolon in lieu of ALT Enter
  • Access Joe
Replies
4
Views
722
Access Joe
A
M
Protecting/Unprotecting all sheets with macro leads to "image" iss
  • MikeR
Replies
3
Views
648
MikeR
M
T
How to Sum Time in Hours & Minutes
  • Teri
Replies
9
Views
537
T. Valko
T
R
Forms
  • Rosie
Replies
1
Views
363
Gord Dibben
G
D
How do I print my spreadsheet to show the formulas of a cell?
  • Donna
Replies
3
Views
1K
Gord Dibben
G
T
Extracting the latest info from 1st sheet and placing into a 2nd s
  • tech1NJ
Replies
1
Views
433
Glenn
G
Z
Locating values in a range and bringing up the corresponding price
  • Zuo
Replies
3
Views
648
Zuo
Z
M
Help simplifying a formula with multiple if's added together...
  • Marc T
Replies
7
Views
738
Daryl S
D
G
Macro help - Investor sheet
  • Goaliemenace
Replies
2
Views
421
Goaliemenace
G
B
Merge data from two separate tables
  • brownmre
Replies
1
Views
622
Duke Carey
D
C
Rounding
  • Curtis
Replies
3
Views
379
Duke Carey
D
R
referencing cell lnking to another tab in Excel that skips 2 colum
  • RD
Replies
2
Views
373
Bernard Liengme
B
J
Need help creating a formula to track % of total responses
  • Jbrose31
Replies
2
Views
376
Duke Carey
D
Back
Top