A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Search Forums
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Showing results 1 to 25 of 100
Search took 1.64 seconds.
Search: Posts made by: Don Guillett[_2_]
Forum: New Users June 5th, 2010, 10:51 PM Posted to microsoft.public.excel.newusers
Replies: 23
Views: 6,590
Posted By Don Guillett[_2_]
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,311
Posted By Don Guillett[_2_]
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: 6,590
Posted By Don Guillett[_2_]
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: 467
Posted By Don Guillett[_2_]
what tab for calculating percent and decimal?

try formatcells
or
right clickformat

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Heidi" wrote in message
Forum: General Discussion June 5th, 2010, 03:05 PM Posted to microsoft.public.excel.misc
Replies: 0
Views: 488
Posted By Don Guillett[_2_]
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: 530
Posted By Don Guillett[_2_]
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: 489
Posted By Don Guillett[_2_]
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: 445
Posted By Don Guillett[_2_]
COUNTA or COUNTIF or COUNT

xl2007

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Steve" wrote in message...
Forum: Worksheet Functions June 4th, 2010, 11:40 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 3
Views: 506
Posted By Don Guillett[_2_]
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: 431
Posted By Don Guillett[_2_]
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: 506
Posted By Don Guillett[_2_]
Formula to pull the lowest supplier name

Sup A Sup B Sup C Minimum Sup Bid Minimum Sup Name
$/lb. $/lb. $/lb. $/lb.
Item 1 1 2 3 1 ?
Item 2 0.5 0.2 0.4 0.2 ...
Forum: Worksheet Functions June 4th, 2010, 09:11 PM Posted to microsoft.public.excel.worksheet.functions
Replies: 4
Views: 445
Posted By Don Guillett[_2_]
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,516
Posted By Don Guillett[_2_]
copy selected rows to second worksheet (NOT Cut + Paste)

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, 09:04 PM Posted to microsoft.public.excel.misc
Replies: 5
Views: 780
Posted By Don Guillett[_2_]
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: 408
Posted By Don Guillett[_2_]
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: 468
Posted By Don Guillett[_2_]
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: 780
Posted By Don Guillett[_2_]
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: 489
Posted By Don Guillett[_2_]
Sorting a list of numbers

sample?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"BRB" wrote in message...
Forum: Worksheet Functions June 4th, 2010, 12:39 AM Posted to microsoft.public.excel.worksheet.functions
Replies: 3
Views: 480
Posted By Don Guillett[_2_]
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: 488
Posted By Don Guillett[_2_]
Increment Value By 1 Each Time Spreadsheet is Opened

It may be better to put in a before_print macro

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"The Project Master" wrote in...
Forum: General Discussion June 3rd, 2010, 11:50 PM Posted to microsoft.public.excel.misc
Replies: 3
Views: 445
Posted By Don Guillett[_2_]
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: 494
Posted By Don Guillett[_2_]
HOW DO I DUPLICATE ONE SHEET MULTIPLE TIMES

Sub makeshts()
For i = 1 To 21
Sheets("Template").Copy After:=Sheets(i)
Next i
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
Forum: General Discussion June 3rd, 2010, 08:18 PM Posted to microsoft.public.excel.misc
Replies: 2
Views: 619
Posted By Don Guillett[_2_]
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: 446
Posted By Don Guillett[_2_]
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: 481
Posted By Don Guillett[_2_]
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...
Showing results 1 to 25 of 100

 
Forum Jump

All times are GMT +1. The time now is 11:51 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 OfficeFrustration.
The comments are property of their posters.