Forum: New Users
June 5th, 2010, 10:51 PM Posted to microsoft.public.excel.newusers
|
Replies: 23
Views: 7,353
The Day After ???
OK Dave, I did that.
When I click on newsgroups and put in excel I get "no matches"
Help an old man figure it out.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Dave...
|
Forum: Worksheet Functions
June 5th, 2010, 10:32 PM Posted to microsoft.public.excel.worksheet.functions
|
Replies: 9
Views: 2,451
Complex AND OR Formula
=IF(AND(RIGHT(E2,2)="1bx",j2=11),1,j2)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Colin Hayes" wrote in message...
|
Forum: New Users
June 5th, 2010, 10:28 PM Posted to microsoft.public.excel.newusers
|
Replies: 23
Views: 7,353
The Day After ???
So, how do you use it?
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Aaron" wrote in message
...
...
|
Forum: Worksheet Functions
June 5th, 2010, 06:50 PM Posted to microsoft.public.excel.worksheet.functions
|
Replies: 1
Views: 541
|
Forum: General Discussion
June 5th, 2010, 03:05 PM Posted to microsoft.public.excel.misc
|
Replies: 0
Views: 588
Sorting a list of numbers
Option Explicit
Sub SASLineEmUP()
Dim lr As Long
Dim i As Long
Dim lc As Long
Application.ScreenUpdating = False
Columns(1).Clear
lr = Cells.Find("*", Cells(Rows.Count, Columns.Count) _
, , ,...
|
Forum: General Discussion
June 5th, 2010, 03:01 PM Posted to microsoft.public.excel.misc
|
Replies: 0
Views: 636
Consolidating data
Sent OP this
Option Explicit
Sub SAS_MakeTable()
Dim lr As Long
Dim c As Range
Dim mm As Double
Dim mr As Long
Dim mc As Double
|
Forum: General Discussion
June 4th, 2010, 11:59 PM Posted to microsoft.public.excel.misc
|
Replies: 3
Views: 593
Sorting a list of numbers
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You...
|
Forum: Worksheet Functions
June 4th, 2010, 11:41 PM Posted to microsoft.public.excel.worksheet.functions
|
Replies: 4
Views: 522
|
Forum: Worksheet Functions
June 4th, 2010, 11:40 PM Posted to microsoft.public.excel.worksheet.functions
|
Replies: 3
Views: 577
Formula to pull the lowest supplier name
I meant
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject...
|
Forum: General Discussion
June 4th, 2010, 11:21 PM Posted to microsoft.public.excel.misc
|
Replies: 1
Views: 539
Consolidating data
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You...
|
Forum: Worksheet Functions
June 4th, 2010, 09:15 PM Posted to microsoft.public.excel.worksheet.functions
|
Replies: 3
Views: 577
|
Forum: Worksheet Functions
June 4th, 2010, 09:11 PM Posted to microsoft.public.excel.worksheet.functions
|
Replies: 4
Views: 522
COUNTA or COUNTIF or COUNT
=sumproduct((b3:b5="bill")*(c3:c5="yes"))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Liz" wrote in message...
|
Forum: New Users
June 4th, 2010, 09:05 PM Posted to microsoft.public.excel.newusers
|
Replies: 2
Views: 2,899
|
Forum: General Discussion
June 4th, 2010, 09:04 PM Posted to microsoft.public.excel.misc
|
Replies: 5
Views: 903
Sumproduct;3 criteria
OP didn't mention version so I gave one that works in BOTH
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Roger Govier" wrote in message...
|
Forum: General Discussion
June 4th, 2010, 09:03 PM Posted to microsoft.public.excel.misc
|
Replies: 3
Views: 495
Macro to affect all sheets
I know that it doesn't make sense but Excel will NOT accept all sheets in a
macro for this. Use the suggested loop. Fast
--
Don Guillett
Microsoft MVP Excel
SalesAid...
|
Forum: General Discussion
June 4th, 2010, 09:01 PM Posted to microsoft.public.excel.misc
|
Replies: 3
Views: 567
Macro/VB coding question
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You...
|
Forum: General Discussion
June 4th, 2010, 04:33 PM Posted to microsoft.public.excel.misc
|
Replies: 5
Views: 903
Sumproduct;3 criteria
Sumproduct may NOT use ENTIRE columns. try k2:k22
SUMPRODUCT(('May YTD Data'!$K2:$K22="New Customer"),('May YTD
Data'!$AB2:$AB22=B6),(month('May YTD Data'!$D2:$D22)=5),'May YTD
Data'!$Q2:$Q22)
--...
|
Forum: General Discussion
June 4th, 2010, 04:30 PM Posted to microsoft.public.excel.misc
|
Replies: 3
Views: 593
|
Forum: Worksheet Functions
June 4th, 2010, 12:39 AM Posted to microsoft.public.excel.worksheet.functions
|
Replies: 3
Views: 551
Looking up next available number
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You...
|
Forum: General Discussion
June 4th, 2010, 12:34 AM Posted to microsoft.public.excel.misc
|
Replies: 2
Views: 590
|
Forum: General Discussion
June 3rd, 2010, 11:50 PM Posted to microsoft.public.excel.misc
|
Replies: 3
Views: 539
divide a string words separated by (number)
Sub SplitCellswith()
For Each n In Range("h2:h6")
c = Application.Substitute(n, " ", "")
p1 = InStr(1, Trim(c), ")")
p2 = InStr(p1 + 1, c, ")") + 1
p3 = InStr(p1 + 1, c, "(") - 1
n.Offset(, 1) =...
|
Forum: General Discussion
June 3rd, 2010, 11:06 PM Posted to microsoft.public.excel.misc
|
Replies: 3
Views: 587
|
Forum: General Discussion
June 3rd, 2010, 08:18 PM Posted to microsoft.public.excel.misc
|
Replies: 2
Views: 712
file with udf extension
http://www.google.com/#hl=en&source=hp&q=*.udf&aq=f&aqi=g3g-s1g3&aql=&oq=&gs_rfai=C_KkU1f8HTKKKAYXUM8vi_dAKAAAAqgQFT9AdQ5A&fp=7ea2d229f2f9fbeb
--
Don Guillett
Microsoft MVP Excel
SalesAid...
|
Forum: Worksheet Functions
June 3rd, 2010, 06:47 PM Posted to microsoft.public.excel.worksheet.functions
|
Replies: 3
Views: 526
Average If
This is an ARRAY formula that must be entered using ctrl+shift+enter
=AVERAGE(IF((A2:A1075),B2:B10))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"carl"...
|
Forum: General Discussion
June 3rd, 2010, 06:36 PM Posted to microsoft.public.excel.misc
|
Replies: 2
Views: 553
Sumif and vlookup Help
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You...
|