Microsoft Excel Worksheet Functions

Post thread
K
Reverse Index and Match Functions
  • karl
Replies
9
Views
745
Max
M
C
Concatenate many rows quickly
  • cmotes
Replies
4
Views
743
T. Valko
T
V
Averaging set of data based on the time
  • voyager1
Replies
2
Views
383
voyager1
V
K
How do I change the name on comments inserted in Excel
  • Kit
Replies
1
Views
516
Bob Phillips
B
D
make a positive number to negative
  • D
Replies
2
Views
454
Stan Brown
S
S
Returning matches from mutiple rows
  • Sunshine
Replies
4
Views
593
T. Valko
T
J
converting files to excel
  • jes
Replies
3
Views
350
volelo
V
N
Using Solver
  • needhelpplease
Replies
2
Views
425
Dana DeLouis
D
A
Drop Down Menu autofilling
  • Aaron
Replies
6
Views
497
Gord Dibben
G
K
How do I vlookup multiple rows with same reference?
  • Kathie C
Replies
2
Views
1K
Herbert Seidenberg
H
B
Text to Numbers
  • Batshon
Replies
4
Views
313
Gord Dibben
G
J
calculating by month
  • Jake
Replies
1
Views
381
Bob Phillips
B
G
Adding fileds in a list based on a lookup
  • Gregory Day
Replies
5
Views
344
sahafi
S
D
Sunday
  • Dale
Replies
6
Views
499
Ron Rosenfeld
R
R
separating linked wrkbooks
  • robzrob
Replies
5
Views
308
JLatham
J
R
help with code in a mack
  • Richard
Replies
5
Views
288
Dave Peterson
D
T
IF function - If false argument query
  • Twishlist
Replies
5
Views
446
Max
M
R
date and time [skipping weekends]
  • rhhince
Replies
8
Views
612
rhhince
R
J
Manipulating data in Multible worksheets
  • Jason Cottrell
Replies
2
Views
419
Jason Cottrell
J
M
shortcut key for selecting the inactive cells surrounding a range
  • Michele
Replies
1
Views
290
Héctor Miguel
H
S
VLookup and cell shading
  • Sherry
Replies
2
Views
750
mvk
M
L
Date Range Conditional Formatting
  • Lynn
Replies
13
Views
2K
T. Valko
T
C
VLOOKUP
  • Clay_TX
Replies
4
Views
418
Pete_UK
P
R
Zero Values
  • robzrob
Replies
2
Views
367
robzrob
R
J
Cumulative days roll-over
  • John MacAllister
Replies
7
Views
760
John MacAllister
J
K
Table feature in Data Menu
  • Katie
Replies
6
Views
320
Max
M
M
Conditional formatting II
  • Mac
Replies
4
Views
342
Mac
M
D
Is there a limit to the number of formulas in an Excel worksheet?
  • Del
Replies
3
Views
704
JP
J
M
pulling data from 2 columns
  • MJJ
Replies
3
Views
456
Pete_UK
P
T
Duplicate rows into new rows based on row value
  • Tom
Replies
5
Views
616
ryguy7272
R
M
Conditional formatting
  • Mac
Replies
3
Views
335
Mac
M
C
trying to consolidate info into one sheet
  • cabirdy
Replies
1
Views
385
Herbert Seidenberg
H
J
PageSetup Macro
  • Julian Glass
Replies
1
Views
331
Stan Brown
S
E
help on sumproduct() - sum by searching for a common sub string in
  • Eddy Stan
Replies
12
Views
713
Bob Phillips
B
R
Search and replace function
  • RichardR
Replies
1
Views
301
Pete_UK
P
J
Generating a new list based on cell criteria
  • JerryS
Replies
1
Views
473
Max
M
T
Need Formula to Find a Match and Then Insert Some Characters
  • Toria
Replies
4
Views
472
Pete_UK
P
G
Convert minutes into hours and minutes
  • Guest
Replies
6
Views
1K
Niek Otten
N
T
Pasting Borders
  • TigerLady
Replies
2
Views
341
Ken Johnson
K
N
Excel Formula to concatenate record from 2 tables
  • Negda
Replies
3
Views
537
Herbert Seidenberg
H
K
Conditional Calculations with Calculated Results
  • Koneko
Replies
1
Views
347
Pete_UK
P
G
Conditional Format Based on Age, but not if blank.
  • Gregory Day
Replies
7
Views
764
Pete_UK
P
G
Count Days more than 180 days prior to today
  • Gregory Day
Replies
4
Views
4K
Gregory Day
G
J
Linking values within an Excel workbook
  • Jerry M.
Replies
1
Views
381
ryguy7272
R
J
How to concatenate cell & text in a text box?
  • Jimbo213
Replies
3
Views
3K
ryguy7272
R
A
#n/a result for vlookup
  • adimar
Replies
5
Views
631
adimar
A
C
How to force data entry with error messages
  • CindyB
Replies
1
Views
434
CindyB
C
S
Sumproduct Offset with an If
  • Steve
Replies
2
Views
547
[email protected]
K
B
Copying formulas
  • bridgeb3
Replies
1
Views
540
Pete_UK
P
S
Need formula in excel for filtering large database
  • Sharkies
Replies
2
Views
625
Sharkies
S
Back
Top