Microsoft Excel Worksheet Functions

S
Vlookup functions which could not recognise similar alphanumerics
  • Shawn
Replies
2
Views
313K
AnimalMagic
A
T
Make cell contents blank upon opening worksheet
  • Tacrier
Replies
1
Views
139K
Max
M
G
Calculating the value of a cell from another cell
  • GPark1018
Replies
2
Views
107K
Gord Dibben
G
G
help with pivot tables
  • Guest
Replies
3
Views
33K
Infinitogool
I
S
Display row of the maximum in a list
  • Sungibungi
Replies
2
Views
219K
T. Valko
T
H
average formula
  • hserphillips
Replies
2
Views
70K
Harlan Grove
H
N
Filter by Date of Birth
  • Naomi
Replies
12
Views
938K
Naomi
N
L
How to Change Column Header from numbers back to letters
  • Luke
Replies
2
Views
258K
FSt1
F
N
Condensing a list with duplicates to a list with non-duplicates
  • Nuclear
Replies
2
Views
239K
M Kan
M
T
How can I filter just 2 columns (separated by another column)?
  • theglove33
Replies
2
Views
56K
Gord Dibben
G
K
What would I set up this formula
  • Karen
Replies
4
Views
316K
David Biddulph
D
S
#VALUE! error message in simple sum function
  • Sandog
Replies
4
Views
235K
Sandog
S
L
Adding sums from different worksheets
  • laurabell
Replies
2
Views
307K
Gord Dibben
G
X
Is it possible to filter using row height in Excel
  • xBRITO
Replies
2
Views
331K
Gord Dibben
G
V
Still need help with IF and Count Function
  • Vicki
Replies
11
Views
1M
T. Valko
T
S
find the cells that represent a code in one cell
  • shane
Replies
1
Views
118K
Gord Dibben
G
S
How do I use a variable as a reference to an array in INDEX
  • Steve Haack
Replies
6
Views
485K
T. Valko
T
T
XL2002 - VLOOKUP with variable Sheet Name
  • Trevor Williams
Replies
3
Views
214K
Pete_UK
P
S
Write a formula using two arrays, across two worksheets
  • Susan
Replies
11
Views
575K
David Biddulph
D
R
IF function
  • Rebecca
Replies
4
Views
162K
David Biddulph
D
J
Multiple If Statements in the same cell
  • JBarsema
Replies
2
Views
238K
ryguy7272
R
L
Adding Rows
  • leimst
Replies
2
Views
68K
ryguy7272
R
S
"IF" Condition
  • shafali
Replies
1
Views
101K
PCLIVE
P
G
How can I calculate total spend on items that have different values
  • gorbash.uk
Replies
1
Views
302K
John C
J
G
INDEX / MATCH with SUMIF/COUNTIF/SUMPRODUCT Statements?
  • Guest
Replies
10
Views
204K
Pinto G
P
S
Formula being replaced by =#N/A
  • Scopar
Replies
1
Views
80K
VoxBox-Richard
V
D
Summing between two dates
  • Don
Replies
6
Views
686K
Pete_UK
P
S
Counting Records Between Two Dates
  • Stevo
Replies
7
Views
304K
Pete_UK
P
R
Exporting list from Excel to PP, I want a new slide for each cell
  • RecycleMicol
Replies
1
Views
57K
Reitanos
R
T
If with multiple or
  • TFMR
Replies
5
Views
147K
John C
J
T
Need to report a count that meets multiple criteria.
  • tkm
Replies
2
Views
237K
Stephen Lloyd
S
D
Excel not correctly calculating formula
  • Darren Ingram
Replies
5
Views
466K
Pete_UK
P
A
how to make a cell mandatory in the excel sheet
  • Asif
Replies
2
Views
155K
Gary Brown
G
V
Multiple Data Validation
  • VoxBox-Richard
Replies
3
Views
66K
Bob Phillips
B
L
convert US dates to UK dates
  • Labuscs
Replies
2
Views
218K
Dave Peterson
D
S
display unique data into third sheet
  • Sri
Replies
3
Views
420K
MYNAMPATI
M
P
if val in col3 is one of 13 codes (list), apply factor to val in c
  • PBcorn
Replies
1
Views
284K
Dave
D
F
Multiple Critiera Sum Array - One critiera to be between two numbers
  • Forgone
Replies
3
Views
266K
Forgone
F
W
IF function? to turn around answers in questionaire
  • Windav
Replies
3
Views
218K
Bob Phillips
B
A
sumproduct help.
  • angel
Replies
3
Views
322K
Bob Phillips
B
S
Regarding Formula for Date and time
  • Samuel Jacob
Replies
1
Views
100K
Bob Phillips
B
M
Lowest two values
  • Muz
Replies
4
Views
230K
Bob Phillips
B
A
Copy & paste block of text number of times equal to value in cell
  • azoll
Replies
1
Views
127K
ryguy7272
R
H
Help required
  • Hassan
Replies
2
Views
167K
Hassan
H
S
MS Excel 2007
  • sherrysboyfriend
Replies
2
Views
101K
RagDyer
R
J
Lookup Formula Question
  • JWNJ
Replies
1
Views
110K
Max
M
A
Ignore blank cells when calculating date for If, Then function
  • AndreaS13
Replies
2
Views
449K
AndreaS13
A
B
SUMIF
  • Brad Bross
Replies
5
Views
250K
RagDyer
R
J
lookup or vlookup
  • jamalhakem
Replies
7
Views
349K
Max
M
E
Exporting data
  • EB21
Replies
3
Views
435K
EB21
E
You must log in or register to post here.
Back
Top