Microsoft Excel Worksheet Functions

Post thread
M
Finding quantity that falls within a range or Tier
  • Mimi
Replies
3
Views
618
Ron Rosenfeld
R
G
Count Non-Blank Values in a Table but only for a range
  • GCRDelphi
Replies
3
Views
474
Pete_UK
P
J
>> vlookup refering to a cell to get wookbook name
  • Jonathan
Replies
1
Views
501
Bob Phillips
B
S
Compare and get the best value
  • Satya Nanduri
Replies
2
Views
387
Satya Nanduri
S
A
Comparing Addresses from 2 different Worksheets
  • AAH
Replies
7
Views
597
Max
M
R
Multiple calculations within cell? Writing in Excel 2000, using inExcel 2003
  • robzrob
Replies
6
Views
2K
John C
J
J
Copy Info from 1 sheet to another within same workbook
  • Julie
Replies
1
Views
380
Gord Dibben
G
D
Printing
  • Dave
Replies
2
Views
209
Gord Dibben
G
U
Data Validation and combination
  • UTResearchAnalyst
Replies
3
Views
460
Gord Dibben
G
J
Filtering
  • Jessica
Replies
1
Views
223
Gord Dibben
G
J
Average of Day and Time
  • Jarod
Replies
3
Views
487
Bob Phillips
B
D
sumif or if or something else????
  • durrienz
Replies
2
Views
468
durrienz
D
J
multiple IF formulas
  • JayDee
Replies
8
Views
411
T. Valko
T
N
FONT COLOUR CHANGE
  • natasha90
Replies
3
Views
396
Jan Bolluyt
J
I
CONCATENATE within SUMPRODUCT
  • Icarus
Replies
14
Views
2K
PCLIVE
P
C
Already exists on the destination workbook
  • ChrisP
Replies
3
Views
509
Dave Peterson
D
D
Formula, automation turn red if value exceed a number
  • Daniel
Replies
3
Views
4K
Pete_UK
P
J
Formulas that refer to a cell in the last row
  • JBoyer
Replies
3
Views
418
JBoyer
J
U
Quday001-Conditional Formatting
  • Udayan
Replies
1
Views
322
Pete_UK
P
B
match or vlookup function formula help
  • Belinda7237
Replies
4
Views
470
Pete_UK
P
S
Minutes/seconds not right ( 24 ??? %$@#$%$)
  • Steve
Replies
4
Views
516
Pete_UK
P
C
Push updates from one workbook to others?
  • ChrisP
Replies
1
Views
339
Pete_UK
P
P
IF and dates
  • PAL
Replies
7
Views
289
PCLIVE
P
H
IF function question
  • hispeaches
Replies
1
Views
383
Pete_UK
P
T
Validation in Field Lists
  • TXDalessandros
Replies
1
Views
247
John C
J
B
Refer to a sheet using a cell value
  • bony_tony
Replies
2
Views
402
bony_tony
B
D
how do I convert English (Canadian) dates to English (US) dates
  • dinertx
Replies
1
Views
608
Mike H
M
K
Look Up two cells
  • Kim
Replies
2
Views
313
John C
J
C
Vlookup in data validation???
  • ChrisP
Replies
1
Views
348
John C
J
U
Quday-Conditional Formatting
  • Udayan
Replies
5
Views
391
Udayan
U
C
"in" function???
  • ChrisP
Replies
2
Views
276
PCLIVE
P
P
HOW CAN I FLAG A CELL IN EXCEL WHEN IT HITS A REORDER LEVEL?
  • PENNY
Replies
2
Views
1K
Meebers
M
G
Hide tab sheet in webpage (Excel)
  • Guest
Replies
7
Views
1K
Hansn
H
M
=SLOPE(OFFSET(INDEX .... Help please
  • Mark K
Replies
9
Views
682
Bernd P
B
A
ideas needed, pls help..
  • angel
Replies
2
Views
379
sajay
S
J
Date Correction
  • JPS
Replies
4
Views
340
JPS
J
S
Hide a sheet with a variable name
  • Scott
Replies
4
Views
530
Scott
S
R
Data Validation lists update orginal cell with list update
  • roniaelm
Replies
3
Views
757
[email protected]
R
D
Lookup function ~ weird is it possible?
  • Daniel Q.
Replies
1
Views
379
Max
M
S
Excel time calculation
  • STS
Replies
3
Views
747
T. Valko
T
R
Test for normality of data
  • Rob
Replies
3
Views
1K
Harlan Grove
H
K
Two way lookup on a table from user input
  • Kim
Replies
1
Views
311
T. Valko
T
T
Payroll lookup
  • Treasur2
Replies
1
Views
373
T. Valko
T
T
Count the Y's in a filtered column that contains Y and N
  • TommyB
Replies
1
Views
472
Teethless mama
T
J
using vlookup
  • Jack
Replies
4
Views
528
Mark
M
T
Searching Multiple rows using VLOOKUP with wildcard(*,?) lookup va
  • Tommy
Replies
3
Views
625
Tommy
T
C
If calculations
  • ClassyCleaning
Replies
3
Views
328
Pete_UK
P
L
XIRR FUNCTION
  • Lynndale
Replies
6
Views
540
Lynndale
L
T
Complex Array sorting issue
  • Tubster
Replies
5
Views
491
Héctor Miguel
H
T
Need Help with Lookup Formula that Also Puts in Text Where Matchin
  • Toria
Replies
6
Views
451
Toria
T
Back
Top