Microsoft Excel Worksheet Functions

G
Count Non-Blank Values in a Table but only for a range
  • GCRDelphi
Replies
3
Views
342K
Pete_UK
P
J
>> vlookup refering to a cell to get wookbook name
  • Jonathan
Replies
1
Views
200K
Bob Phillips
B
S
Compare and get the best value
  • Satya Nanduri
Replies
2
Views
85K
Satya Nanduri
S
A
Comparing Addresses from 2 different Worksheets
  • AAH
Replies
7
Views
660K
Max
M
R
Multiple calculations within cell? Writing in Excel 2000, using inExcel 2003
  • robzrob
Replies
6
Views
748K
John C
J
J
Copy Info from 1 sheet to another within same workbook
  • Julie
Replies
1
Views
40K
Gord Dibben
G
D
Printing
  • Dave
Replies
2
Views
57K
Gord Dibben
G
U
Data Validation and combination
  • UTResearchAnalyst
Replies
3
Views
222K
Gord Dibben
G
J
Filtering
  • Jessica
Replies
1
Views
24K
Gord Dibben
G
J
Average of Day and Time
  • Jarod
Replies
3
Views
403K
Bob Phillips
B
D
sumif or if or something else????
  • durrienz
Replies
2
Views
236K
durrienz
D
J
multiple IF formulas
  • JayDee
Replies
8
Views
450K
T. Valko
T
N
FONT COLOUR CHANGE
  • natasha90
Replies
3
Views
392K
Jan Bolluyt
J
I
CONCATENATE within SUMPRODUCT
  • Icarus
Replies
14
Views
1M
PCLIVE
P
C
Already exists on the destination workbook
  • ChrisP
Replies
3
Views
158K
Dave Peterson
D
D
Formula, automation turn red if value exceed a number
  • Daniel
Replies
3
Views
373K
Pete_UK
P
J
Formulas that refer to a cell in the last row
  • JBoyer
Replies
3
Views
324K
JBoyer
J
U
Quday001-Conditional Formatting
  • Udayan
Replies
1
Views
204K
Pete_UK
P
B
match or vlookup function formula help
  • Belinda7237
Replies
4
Views
392K
Pete_UK
P
S
Minutes/seconds not right ( 24 ??? %$@#$%$)
  • Steve
Replies
4
Views
300K
Pete_UK
P
C
Push updates from one workbook to others?
  • ChrisP
Replies
1
Views
301K
Pete_UK
P
P
IF and dates
  • PAL
Replies
7
Views
611K
PCLIVE
P
H
IF function question
  • hispeaches
Replies
1
Views
284K
Pete_UK
P
T
Validation in Field Lists
  • TXDalessandros
Replies
1
Views
109K
John C
J
B
Refer to a sheet using a cell value
  • bony_tony
Replies
2
Views
552K
bony_tony
B
D
how do I convert English (Canadian) dates to English (US) dates
  • dinertx
Replies
1
Views
301K
Mike H
M
K
Look Up two cells
  • Kim
Replies
2
Views
69K
John C
J
C
Vlookup in data validation???
  • ChrisP
Replies
1
Views
324K
John C
J
U
Quday-Conditional Formatting
  • Udayan
Replies
5
Views
466K
Udayan
U
C
"in" function???
  • ChrisP
Replies
2
Views
68K
PCLIVE
P
P
HOW CAN I FLAG A CELL IN EXCEL WHEN IT HITS A REORDER LEVEL?
  • PENNY
Replies
2
Views
234K
Meebers
M
G
Hide tab sheet in webpage (Excel)
  • Guest
Replies
7
Views
683K
Hansn
H
M
=SLOPE(OFFSET(INDEX .... Help please
  • Mark K
Replies
9
Views
870K
Bernd P
B
A
ideas needed, pls help..
  • angel
Replies
2
Views
252K
sajay
S
J
Date Correction
  • JPS
Replies
4
Views
44K
JPS
J
S
Hide a sheet with a variable name
  • Scott
Replies
4
Views
211K
Scott
S
R
Data Validation lists update orginal cell with list update
  • roniaelm
Replies
3
Views
430K
[email protected]
R
D
Lookup function ~ weird is it possible?
  • Daniel Q.
Replies
1
Views
181K
Max
M
S
Excel time calculation
  • STS
Replies
3
Views
280K
T. Valko
T
R
Test for normality of data
  • Rob
Replies
3
Views
95K
Harlan Grove
H
K
Two way lookup on a table from user input
  • Kim
Replies
1
Views
15K
T. Valko
T
T
Payroll lookup
  • Treasur2
Replies
1
Views
110K
T. Valko
T
T
Count the Y's in a filtered column that contains Y and N
  • TommyB
Replies
1
Views
174K
Teethless mama
T
J
using vlookup
  • Jack
Replies
4
Views
166K
Mark
M
T
Searching Multiple rows using VLOOKUP with wildcard(*,?) lookup va
  • Tommy
Replies
3
Views
25K
Tommy
T
C
If calculations
  • ClassyCleaning
Replies
3
Views
250K
Pete_UK
P
L
XIRR FUNCTION
  • Lynndale
Replies
6
Views
421K
Lynndale
L
T
Complex Array sorting issue
  • Tubster
Replies
5
Views
111K
Héctor Miguel
H
T
Need Help with Lookup Formula that Also Puts in Text Where Matchin
  • Toria
Replies
6
Views
349K
Toria
T
A
password protected workbook
  • Ann
Replies
4
Views
217K
Ann
A
You must log in or register to post here.
Back
Top