Groups
Sign in
Groups
microsoft.public.excel.worksheetfunctions
Conversations
About
Send feedback
Help
info
Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Learn more
microsoft.public.excel.worksheetfunctions
Contact owners and managers
1–30 of 8220
Mark all as read
Report group
0 selected
Ma...@getfucked.com
11/10/17
Uploads - What is wrong with Easynews
Looking for Star Trek Discovery season 1 Episodes 6 onwards in english. Why does it seem there are no
unread,
Uploads - What is wrong with Easynews
Looking for Star Trek Discovery season 1 Episodes 6 onwards in english. Why does it seem there are no
11/10/17
Unknown Soldier
, …
Rich/rerat
7
3/5/08
SORTING BETWEEN WORKSHEETS
Unknown Soldier, Try the following macro after you do the following: 1. On Sheet 1 & 2 Place the
unread,
SORTING BETWEEN WORKSHEETS
Unknown Soldier, Try the following macro after you do the following: 1. On Sheet 1 & 2 Place the
3/5/08
Felsa Satlow
, …
ilia
4
3/2/08
countifs function
Easy enough to check. =TODAY()=INT(TODAY()) =NOW()=INT(NOW()) return, respectively TRUE FALSE Was
unread,
countifs function
Easy enough to check. =TODAY()=INT(TODAY()) =NOW()=INT(NOW()) return, respectively TRUE FALSE Was
3/2/08
Kent J
3/2/08
Update data..?
Hi all, I have data in Excel 2007 from a SQL-server table. Can I use Excel to update the data on SQL-
unread,
Update data..?
Hi all, I have data in Excel 2007 from a SQL-server table. Can I use Excel to update the data on SQL-
3/2/08
TFTAJL...@spammotel.com
,
Hoss
4
3/1/08
Count unique values based on a condition
You're welcome. I can't take credit for that though. I had the same problem recently and
unread,
Count unique values based on a condition
You're welcome. I can't take credit for that though. I had the same problem recently and
3/1/08
LewCou...@gmail.com
2/27/08
Goal Seek error?? 2007
Put 35000 in cell A1. Put 50000 in cell A2. In A3 put =A1/A2. It should equal .7. Now do a goal seek
unread,
Goal Seek error?? 2007
Put 35000 in cell A1. Put 50000 in cell A2. In A3 put =A1/A2. It should equal .7. Now do a goal seek
2/27/08
Richard
, …
NoodNutt
3
2/23/08
Selection
Depending on what you are going to do after you have selected your range 10:250 you might consider
unread,
Selection
Depending on what you are going to do after you have selected your range 10:250 you might consider
2/23/08
Shawn Morneau
,
NoodNutt
2
2/23/08
VLOOKUP only works when =Today() is used in formula, no other dates
Newbie to Excel 2007, but I use AccessDB. most date functions that I know are: Excel = Now() Access =
unread,
VLOOKUP only works when =Today() is used in formula, no other dates
Newbie to Excel 2007, but I use AccessDB. most date functions that I know are: Excel = Now() Access =
2/23/08
NoodNutt
2/23/08
Filtering a list box from a cell value
G'day Ppl Can someone assist me with the steps of the above subject using Excel 2007. Example: If
unread,
Filtering a list box from a cell value
G'day Ppl Can someone assist me with the steps of the above subject using Excel 2007. Example: If
2/23/08
EC II
2/21/08
Exel Working With X-Cart
Has anyone had any experience working with the Programs Excel and X-Cart to complete a website that
unread,
Exel Working With X-Cart
Has anyone had any experience working with the Programs Excel and X-Cart to complete a website that
2/21/08
nwhu...@gmail.com
, …
Mangesh
3
2/20/08
IF Function question
Right click on the control (checkbox in your case). Go to properties. Linked Cell. Mention some cell
unread,
IF Function question
Right click on the control (checkbox in your case). Go to properties. Linked Cell. Mention some cell
2/20/08
Art Wrok
,
Mangesh
2
2/20/08
Date Difference
you could try: =DATEDIF(DateofBirth,EndofYear,"m")/12 On Feb 19, 12:25 am, Art Wrok <
unread,
Date Difference
you could try: =DATEDIF(DateofBirth,EndofYear,"m")/12 On Feb 19, 12:25 am, Art Wrok <
2/20/08
Dave
,
Don Guillett
2
2/6/08
Excel functions - need some guidance.
assuming values in col K, to get min 14.95 =MIN(K:K) assuming your 1-5 in col H to get 4 =INDEX(H:H,
unread,
Excel functions - need some guidance.
assuming values in col K, to get min 14.95 =MIN(K:K) assuming your 1-5 in col H to get 4 =INDEX(H:H,
2/6/08
calum...@gmail.com
2/6/08
Create A Unique List From Multiple Tabs Using Formula
Hi, I have six sets of single column data (integers only) on six different tabs of the same
unread,
Create A Unique List From Multiple Tabs Using Formula
Hi, I have six sets of single column data (integers only) on six different tabs of the same
2/6/08
cmo...@gmail.com
,
ilia
3
2/5/08
Spell Check function in an IF statement?
Hmm... I just realized that this won't work, as CheckSpelling always returns true when inside a
unread,
Spell Check function in an IF statement?
Hmm... I just realized that this won't work, as CheckSpelling always returns true when inside a
2/5/08
Jeff
, …
ilia
4
1/31/08
SUMIF or SUMIFS
Oh, and you can use full-column references with SUMIFS: =SUMIFS(C:C,A:A,">=1310",A:A,
unread,
SUMIF or SUMIFS
Oh, and you can use full-column references with SUMIFS: =SUMIFS(C:C,A:A,">=1310",A:A,
1/31/08
Esradekan
,
ilia
3
1/29/08
Run a macro depending on cell value
Oops! Here is what I actually meant: Private Sub Worksheet_Change(ByVal Target As Range) Dim d As
unread,
Run a macro depending on cell value
Oops! Here is what I actually meant: Private Sub Worksheet_Change(ByVal Target As Range) Dim d As
1/29/08
iccr...@gmail.com
,
Pete_UK
2
1/25/08
sumproduct returning odd results
Increase the number of decimal places that can be seen in column G, to check what values you have.
unread,
sumproduct returning odd results
Increase the number of decimal places that can be seen in column G, to check what values you have.
1/25/08
ste...@hotmail.com
, …
Dave Peterson
5
1/22/08
Text upside down!
Maybe you could use WordArt instead? In xl2003: Insert|Picture|WordArt It may look prettier. stevewy@
unread,
Text upside down!
Maybe you could use WordArt instead? In xl2003: Insert|Picture|WordArt It may look prettier. stevewy@
1/22/08
rennier...@za.abb.com
,
ilia
2
1/8/08
Creating worksheets
If you want some VBA code for this, you'd better post two things. One, your employee list format.
unread,
Creating worksheets
If you want some VBA code for this, you'd better post two things. One, your employee list format.
1/8/08
Atty
1/4/08
HELP !!
I am working on a 20 page worksheet and I need data copied from worksheet 1 to 2 -3 etc. I know the
unread,
HELP !!
I am working on a 20 page worksheet and I need data copied from worksheet 1 to 2 -3 etc. I know the
1/4/08
fiv...@yahoo.com
1/2/08
M'I`5'Pe rsecution haras sment at work
-=-=-=-=-=-=-=-=-=-=-=-= -=. harassment at work -= -=-=-=-=-=-=-=-=-=-=-=-= Once I stopped watching
unread,
M'I`5'Pe rsecution haras sment at work
-=-=-=-=-=-=-=-=-=-=-=-= -=. harassment at work -= -=-=-=-=-=-=-=-=-=-=-=-= Once I stopped watching
1/2/08
fvmf...@bigfoot.com
1/2/08
M`I'5-Pers ecution - why the secu rity ser vices?
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -= why the. security services? -= -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
unread,
M`I'5-Pers ecution - why the secu rity ser vices?
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -= why the. security services? -= -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
1/2/08
fvi...@bigfoot.com
1/2/08
M.I,5-Pers ecution . wh y t he se curity ser vices?
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -= why. the security services? -= -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
unread,
M.I,5-Pers ecution . wh y t he se curity ser vices?
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -= why. the security services? -= -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
1/2/08
feve...@bigfoot.com
1/2/08
M,I.5'Pers ecution , th eir method s a nd tactic s
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -= MI5: methods and. tactics -= -=-=-=-=-=-=-=-=-=-=-=-=-=-=-= They
unread,
M,I.5'Pers ecution , th eir method s a nd tactic s
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -= MI5: methods and. tactics -= -=-=-=-=-=-=-=-=-=-=-=-=-=-=-= They
1/2/08
vme...@gmail.com
1/1/08
M-I,5-Persecut ion - t heir m ethods an d tact ics
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -= MI5: methods. and tactics -= -=-=-=-=-=-=-=-=-=-=-=-=-=-=-= They
unread,
M-I,5-Persecut ion - t heir m ethods an d tact ics
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -= MI5: methods. and tactics -= -=-=-=-=-=-=-=-=-=-=-=-=-=-=-= They
1/1/08
fmem...@gmail.com
1/1/08
M.I,5`Persecuti on ` my response to t he harassme nt
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -= my response. to the harassment -= -=-=-=-=-=-=-=-=-=-=-=-=-=-=
unread,
M.I,5`Persecuti on ` my response to t he harassme nt
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -= my response. to the harassment -= -=-=-=-=-=-=-=-=-=-=-=-=-=-=
1/1/08
fv...@gmail.com
1/1/08
M I.5'Persecut ion , pur pose in p ublicizing it ; censorship in u k.* newsgr oups
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -= purpose in publicizing it;
unread,
M I.5'Persecut ion , pur pose in p ublicizing it ; censorship in u k.* newsgr oups
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -= purpose in publicizing it;
1/1/08
femf...@gmail.com
1/1/08
M`I'5-Persecu tion - a buse in s et-up situations and in publ ic
-=-=-=-=-=-=-=-=-=-=-=-=--=-=-=-=-=-=-=-=-=-=- -= abuse in set-up situations. and in public -= -=-=-=
unread,
M`I'5-Persecu tion - a buse in s et-up situations and in publ ic
-=-=-=-=-=-=-=-=-=-=-=-=--=-=-=-=-=-=-=-=-=-=- -= abuse in set-up situations. and in public -= -=-=-=
1/1/08
ei...@gmail.com
1/1/08
M-I'5`Pers ecution ` wh y wo n't th e B ritish po lice do thei r j ob a nd pu t a sto p to it ?
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -= why won't. the British
unread,
M-I'5`Pers ecution ` wh y wo n't th e B ritish po lice do thei r j ob a nd pu t a sto p to it ?
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -= why won't. the British
1/1/08