Microsoft Excel Worksheet Functions

S
Data Validation
  • SB
Replies
1
Views
123K
Sean Timmons
S
E
Return cell referance of the first cell that equals a value?
  • Enginerd
Replies
5
Views
170K
T. Valko
T
M
trim cells with space in betwen numbers in cell
  • Morten
Replies
2
Views
355K
Luke M
L
J
count scheduled staff between hours
  • jat
Replies
1
Views
337K
amin
A
G
how do i combine text and formula calculation in same cell
  • gsm
Replies
5
Views
55K
T. Valko
T
G
Difficulty with Sum+IF Function
  • Gmania-1980
Replies
10
Views
642K
T. Valko
T
J
macro to sum select columns in all workseets within a workbook
  • Jodie
Replies
2
Views
232K
Jodie
J
L
variable formula
  • LP23294
Replies
4
Views
476K
T. Valko
T
M
Linking Cells
  • MickNick
Replies
1
Views
18K
Mike H
M
Z
Vlookup array formula problem
  • Zach
Replies
2
Views
425K
Zach
Z
J
Conditional Formatting - comparison with another cell
  • Jezza
Replies
4
Views
364K
Sean Timmons
S
A
Can "countifs" be utilized to return a count of unique values?
  • ascottbag-hcm
Replies
1
Views
200K
Jacob Skaria
J
T
Right align positive and neg numbers using brackets around neg #s
  • Terri
Replies
1
Views
124K
Jacob Skaria
J
J
sumif
  • Judith
Replies
2
Views
185K
T. Valko
T
F
Conditional format a column based on value in a different column
  • Friday
Replies
3
Views
464K
Jacob Skaria
J
B
Excel function
  • bfrad
Replies
5
Views
65K
bfrad
B
G
If statements in a Vlookup.
  • Gallarita
Replies
2
Views
209K
Sean Timmons
S
C
V lookup
  • CandiC
Replies
1
Views
238K
Sean Timmons
S
N
Copy Transpose and Link Data
  • Neil
Replies
1
Views
211K
Jacob Skaria
J
R
Linking a workbook to worksheets
  • Ron Purpura
Replies
1
Views
260K
Jacob Skaria
J
R
Locate merged cells to sort on 3 columns
  • Rob B
Replies
2
Views
430K
Luke M
L
C
Simple Q - Multiple IF (And) Statement
  • cjwenngatz
Replies
1
Views
35K
Glenn
G
M
how do i sort my excel worksheet in
  • miabelladolce
Replies
7
Views
270K
BEOPS
B
A
Can u help me plz??
  • alsalmioxy
Replies
0
Views
92K
alsalmioxy
A
S
How do I display data refresh date and time
  • Shree
Replies
2
Views
147K
Srivathsava Madhugiri
S
C
any ideas if this can be done
  • CarlM
Replies
2
Views
135K
CarlM
C
H
Array formulas slows spreadsheet
  • Huggy
Replies
6
Views
406K
T. Valko
T
P
IF(AND with date comparison
  • PSU35
Replies
4
Views
368K
PSU35
P
V
To remove numbers in a cell with out using the macro
  • Vital_ar
Replies
3
Views
323K
Vital_ar
V
T
How to create a hyperlink to open a file with part of the name
  • tsraj
Replies
4
Views
2M
tsraj
T
S
Round it off
  • Sri Harsha
Replies
3
Views
287K
Jacob Skaria
J
D
SumPRODUCT - calculating result??
  • Dhazmo
Replies
5
Views
411K
Dhazmo
D
K
Remove hyperlink in Excel worksheet
  • Kent
Replies
5
Views
190K
Kent
K
E
Moving Average
  • Elton Law
Replies
8
Views
387K
Elton Law
E
J
Unique records formula & zero entries
  • jc132568
Replies
9
Views
620K
T. Valko
T
A
how to insert rows inbetween rows of data ?
  • Azeem
Replies
1
Views
168K
Jacob Skaria
J
M
function to retrieve array name
  • Monty
Replies
6
Views
459K
Jacob Skaria
J
P
Additional IF Function
  • Pran
Replies
4
Views
115K
Pran
P
R
SumProd from 2 columns and date range
  • roy.okinawa
Replies
6
Views
334K
roy.okinawa
R
J
formatting a sentence with functions
  • Josh Craig
Replies
2
Views
178K
Josh Craig
J
R
Separate colum
  • Raj Kumar
Replies
2
Views
220K
Ron Rosenfeld
R
E
highlight the highest cell in a column
  • exhub58
Replies
1
Views
271K
Jacob Skaria
J
P
Additional IF Function
  • Pran
Replies
2
Views
133K
Jacob Skaria
J
L
average without min qty
  • Looping through
Replies
1
Views
208K
Jacob Skaria
J
P
want to create a link to another worksheet in another workbook
  • pkt
Replies
1
Views
349K
Gord Dibben
G
V
Vlookup i think >.<
  • Vader
Replies
6
Views
316K
Vader
V
C
Sumproduct problem
  • Chris
Replies
2
Views
264K
Chris
C
J
To All you Senior Guys out there.
  • John
Replies
7
Views
716K
John
J
K
returning text; alternative to sumproduct/sumif?
  • ker_01
Replies
4
Views
450K
Ashish Mathur
A
M
Copying and pasting with SUMIF and COUNTIF
  • mwdawg721
Replies
3
Views
472K
Gord Dibben
G
You must log in or register to post here.
Back
Top