Microsoft Excel Worksheet Functions

G
Automatically generating a number range
  • Guest
Replies
2
Views
165K
Guest
G
S
Return Min & Max value of Conditional Formatted cells
  • Sam via OfficeKB.com
2
Replies
20
Views
2M
Domenic
D
D
Using IF function when "#value!" is present.
  • db_murray
Replies
3
Views
80K
Biff
B
G
ignore #N/A in a sum?
  • Guest
Replies
3
Views
138K
Gord Dibben
G
G
Sorting rows by pairs
  • Guest
Replies
5
Views
111K
Dave Peterson
D
G
How to link a drop down value to a cell in a different worksheet?
  • Guest
Replies
1
Views
207K
Biff
B
G
Working with hyperlinks
  • Guest
Replies
1
Views
42K
Guest
G
D
Text String Seperation.
  • db_murray
Replies
2
Views
185K
[email protected]
D
C
Delete first two characters in a cell...
  • ChuckF
Replies
6
Views
315K
Guest
G
G
Document at 100% doesn't print correctly
  • Guest
Replies
2
Views
65K
Guest
G
G
why is the zero falling off a zip code in excel?
  • Guest
Replies
3
Views
178K
Dave Peterson
D
G
range inside RANK formula based on contents of other cells
  • Guest
Replies
3
Views
486K
Biff
B
G
Formula Help
  • Guest
Replies
5
Views
680K
Guest
G
G
Please help w/Sumproduct!
  • Guest
Replies
2
Views
175K
shail
S
G
Need a AHLookup function
  • Guest
Replies
1
Views
140K
shail
S
G
Sumproduct (Sumif) with Nested Or Criteria
  • Guest
Replies
9
Views
322K
shail
S
G
Excel: Changing "numeric $" to "text $" in a different cell.
  • Guest
Replies
1
Views
55K
Guest
G
G
update link
  • Guest
Replies
1
Views
183K
Dave Peterson
D
G
Delete the number "49" from each cell in a column
  • Guest
Replies
18
Views
622K
Gord Dibben
G
V
a exact string search inquiry
  • vito
Replies
9
Views
133K
Guest
G
G
automatically fill in blank cells??
  • Guest
Replies
6
Views
72K
Gord Dibben
G
J
Transferring data from one worksheet or workbook to another
  • Janine
Replies
5
Views
402K
[email protected]
S
S
Converting Numeric values to Text
  • shail
Replies
2
Views
392K
shail
S
G
Random number selection
  • Guest
Replies
5
Views
221K
Guest
G
G
a cell to display number of days in a month given in another cell
  • Guest
Replies
1
Views
71K
Franz Verga
F
G
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook)
  • Guest
Replies
0
Views
417K
[email protected]
S
G
Convert column data to semicolon delimited text string
  • Guest
Replies
1
Views
429K
Guest
G
G
total on filtered data?
  • Guest
Replies
3
Views
205K
Pete_UK
P
A
How to remove commas from a downloaded .dat file?
  • arvind
Replies
3
Views
197K
arvind
A
G
Problems with MAX
  • Guest
Replies
6
Views
242K
Guest
G
J
linking items from drop down list in excel
  • jog
Replies
1
Views
138K
Guest
G
G
Limiting what it displayed from drop down menu
  • Guest
Replies
4
Views
260K
Guest
G
G
How do I arrange the worksheets in my workbook alphabetically?
  • Guest
Replies
2
Views
232K
Jim Cone
J
G
Complex IF
  • Guest
Replies
5
Views
133K
Guest
G
G
I need help with a text and quantity summary report.
  • Guest
Replies
2
Views
138K
Guest
G
G
How do I delete specified times from a spreadsheet
  • Guest
Replies
1
Views
86K
Roger Govier
R
G
Creating an Invoice
  • Guest
Replies
1
Views
314K
Roger Govier
R
K
Extending VLOOKUP
  • Krish
Replies
2
Views
76K
Guest
G
G
How to use vlookup when lookup contains number and letters
  • Guest
Replies
4
Views
173K
Biff
B
G
Function for Totals
  • Gymclass14
Replies
1
Views
39K
Dave Peterson
D
G
simply function not work
  • Guest
Replies
10
Views
126K
Guest
G
S
Dual Formatting in Macro
  • Slashman
Replies
9
Views
592K
Ron Rosenfeld
R
P
strings in a range
  • Peter Morris
Replies
4
Views
188K
Peter Morris
P
J
What is the Excel equivalent of the CELL function?
  • JP
Replies
8
Views
424K
JP
J
G
Reading results for automated Myers Briggs Type Indicator?
  • Guest
Replies
2
Views
60K
Guest
G
J
Excel formula help needed-How to separate last and first names?
  • Jan
Replies
2
Views
90K
Jan
J
P
Vlookup by rows and columns
  • puukoi
Replies
2
Views
356K
puukoi
P
G
entry not removed in pivot table pull down filter
  • Guest
Replies
1
Views
66K
Debra Dalgleish
D
A
copy formats vlookup
  • Andre Ronda
Replies
1
Views
208K
Dave Peterson
D
G
Excel error:ROUND(1000.2555-999,3)=1.255
  • Guest
Replies
5
Views
156K
Guest
G
You must log in or register to post here.
Back
Top