Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I am quite the novice at using Excel. I'm trying to create a set of BINGO cards for a church group and I'm having trouble figuring it out. I saw a post about something called RAND function but I don't know what that means. <br><br>What I need is 56 unique cards with 5 columns and 5 rows each. The cards will be using the numbers 1-24 leaving the center square blank or "0". <br><br>Can anyone please assist?

0 |

4/30/2010 8:52:54 PM

This is a multi-part message in MIME format. ------=_NextPart_000_0090_01CAE878.159471D0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable TomKC - Have you looked at any of the items returned when you use Google or Bing = or some other search engine to look for "excel bingo cards" (without the = quotes)? You can get information about the RAND worksheet function using Excel's = built-in Help. - Mike http://www.MikeMiddleton.com <TomKC@officeformac.com> wrote in message = news:59bb7bbc.-1@webcrossing.JaKIaxP2ac0... Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) = Processor: Intel I am quite the novice at using Excel. I'm trying to = create a set of BINGO cards for a church group and I'm having trouble = figuring it out. I saw a post about something called RAND function but I = don't know what that means.=20 What I need is 56 unique cards with 5 columns and 5 rows each. The = cards will be using the numbers 1-24 leaving the center square blank or = "0".=20 Can anyone please assist? ------=_NextPart_000_0090_01CAE878.159471D0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META content=3Dtext/html;charset=3Diso-8859-1 = http-equiv=3DContent-Type> <META name=3DGENERATOR content=3D"MSHTML 8.00.7600.16535"></HEAD> <BODY style=3D"PADDING-LEFT: 10px; PADDING-RIGHT: 10px; PADDING-TOP: = 15px"=20 id=3DMailContainerBody leftMargin=3D0 topMargin=3D0 = CanvasTabStop=3D"true"=20 name=3D"Compose message area"> <DIV><FONT face=3DCalibri>TomKC -</FONT></DIV> <DIV><FONT face=3DCalibri></FONT> </DIV> <DIV><FONT face=3DCalibri>Have you looked at any of the items returned = when you=20 use Google or Bing or some other search engine to look for "excel bingo = cards"=20 (without the quotes)?</FONT></DIV> <DIV><FONT face=3DCalibri></FONT> </DIV> <DIV><FONT face=3DCalibri>You can get information about the RAND = worksheet=20 function using Excel's built-in Help.</FONT></DIV> <DIV><FONT face=3DCalibri></FONT> </DIV> <DIV><FONT face=3DCalibri>- Mike</FONT></DIV> <DIV><FONT face=3DCalibri><A=20 href=3D"http://www.MikeMiddleton.com">http://www.MikeMiddleton.com</A></F= ONT></DIV> <DIV><FONT face=3DCalibri></FONT> </DIV> <DIV> </DIV> <BLOCKQUOTE=20 style=3D"BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; = PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px"> <DIV><<A=20 href=3D"mailto:TomKC@officeformac.com">TomKC@officeformac.com</A>> = wrote in=20 message <A=20 = href=3D"news:59bb7bbc.-1@webcrossing.JaKIaxP2ac0">news:59bb7bbc.-1@webcro= ssing.JaKIaxP2ac0</A>...</DIV>Version:=20 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I = am=20 quite the novice at using Excel. I'm trying to create a set of BINGO = cards for=20 a church group and I'm having trouble figuring it out. I saw a post = about=20 something called RAND function but I don't know what that means. = <BR><BR>What=20 I need is 56 unique cards with 5 columns and 5 rows each. The cards = will be=20 using the numbers 1-24 leaving the center square blank or "0". = <BR><BR>Can=20 anyone please assist?</BLOCKQUOTE></BODY></HTML> ------=_NextPart_000_0090_01CAE878.159471D0--

0 |

4/30/2010 10:16:17 PM

> Mike, <br><br>I found an example at <a href="http://blog.contextures.com/archives/2009/03/12/create-bingo-cards-in-excel/">http://blog.contextures.com/archives/2009/03/12/create-bingo-cards-in-excel/</a> <br><br>I was able to cut it down to 25 in the first set but I'm getting an NUM error in the second two sets and I don't know how to fix it. <br><br>Also to clarify my needs more specifically, I don't need the BINGO letter/number combination. I just need 56 cards that are unique that contain 24 numbers. <br><br>FYI, I'm now told I can use 1-30 from my number selection if that helps. <br><br>(In fact they will be replacing the numbers with symbols before then print them and that's why the limit on the numbers used as they only have 30 symbols.) <br><br>Thanks, <br> TomKC <br><br>> TomKC� - <br> > � <br> > Have you looked at any of the items returned when you <br> > use Google or Bing or some other search engine to look for "excel bingo cards" <br> > (without the quotes)? <br> > � <br> > You can get information about the RAND worksheet <br> > function using Excel's built-in Help. <br> > � <br> > -� Mike <br> > href="<a href="http://www.MikeMiddleton.com">http://www.MikeMiddleton.com</a>"><a href="http://www.MikeMiddleton.com">http://www.MikeMiddleton.com</a> <br> > � <br> > � <br> > style="BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px"> <br> > < href="mailto:TomKC@officeformac.com">TomKC@officeformac.com> wrote in <br> > message href="news:59bb7bbc.-1@webcrossing.JaKIaxP2ac0">news:59bb7bbc.-1@webcrossing.JaKIaxP2ac0...Version: <br> > 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I am <br> > quite the novice at using Excel. I'm trying to create a set of BINGO cards for <br> > a church group and I'm having trouble figuring it out. I saw a post about <br> > something called RAND function but I don't know what that means. What <br> > I need is 56 unique cards with 5 columns and 5 rows each. The cards will be <br> > using the numbers 1-24 leaving the center square blank or "0". Can <br> > anyone please assist?

0 |

4/30/2010 11:28:00 PM

Hi Tom: A "NUM" error means "The number being input to this formula is not acceptable". Usually, because it's not a number at all... See the Excel Help topic "Correct a #NUM! Error" To get help with errors in here, you need to show us the formula you are using, otherwise all we can say is "Sorry, don't know..." Cheers On 1/05/10 9:28 AM, in article 59bb7bbc.1@webcrossing.JaKIaxP2ac0, "TomKC@officeformac.com" <TomKC@officeformac.com> wrote: >> Mike, > > I found an example at > http://blog.contextures.com/archives/2009/03/12/create-bingo-cards-in-excel/ > > I was able to cut it down to 25 in the first set but I'm getting an NUM error > in the second two sets and I don't know how to fix it. > > Also to clarify my needs more specifically, I don't need the BINGO > letter/number combination. I just need 56 cards that are unique that contain > 24 numbers. > > FYI, I'm now told I can use 1-30 from my number selection if that helps. > > (In fact they will be replacing the numbers with symbols before then print > them and that's why the limit on the numbers used as they only have 30 > symbols.) > > Thanks, > TomKC > >> TomKC� - >> � >> Have you looked at any of the items returned when you >> use Google or Bing or some other search engine to look for "excel bingo >> cards" >> (without the quotes)? >> � >> You can get information about the RAND worksheet >> function using Excel's built-in Help. >> � >> -� Mike >> href="http://www.MikeMiddleton.com">http://www.MikeMiddleton.com >> � >> � >> style="BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; PADDING-RIGHT: >> 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px"> >> TomKC@officeformac.com> wrote in >> message >> href="news:59bb7bbc.-1@webcrossing.JaKIaxP2ac0">news:59bb7bbc.-1@webcrossing. >> JaKIaxP2ac0...Version: >> 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I am >> quite the novice at using Excel. I'm trying to create a set of BINGO cards >> for >> a church group and I'm having trouble figuring it out. I saw a post about >> something called RAND function but I don't know what that means. What >> I need is 56 unique cards with 5 columns and 5 rows each. The cards will be >> using the numbers 1-24 leaving the center square blank or "0". Can >> anyone please assist? -- The email below is my business email -- Please do not email me about forum matters unless I ask you to; or unless you intend to pay! John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer, McGhie Information Engineering Pty Ltd Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:john@mcghie.name

0 |

5/2/2010 1:23:05 AM

John, <br><br>That makes total sense. The first group is B2-F2 thru B6-F6 (D4 is open) <br><br>The next group is B9-F9 thru B13-F13 <br><br>The last group is B16-F16 & B20-F20 <br><br>In the second group I'm getting errors in these cell all the way thru the end of the third group. <br><br>When I select Trace error for example in B9 it shows a dotted line with a small table symbol to D7 and on C9 it shows a similar dotted line to A7. Both of which are blank cells. <br><br>Thanks for any help. <br><br>============================================ <br><br>This is cell B9 <br> =INDEX(Numbers!$P$1:$P$5,MATCH(LARGE(Numbers!$Q$1:$Q$5,ROW()-3),Numbers!$Q$1:$Q$5,0)) <br><br>C9 <br> =INDEX(Numbers!$S$1:$S$1,MATCH(LARGE(Numbers!$T$1:$T$5,ROW()-3),Numbers!$T$1:$T$5,0)) <br><br>D9 <br> =INDEX(Numbers!$V$1:$V$5,MATCH(LARGE(Numbers!$W$1:$W$5,ROW()-3),Numbers!$W$1:$W$5,0)) <br><br>E9 <br> =INDEX(Numbers!$Y$1:$Y$5,MATCH(LARGE(Numbers!$Z$1:$Z$5,ROW()-3),Numbers!$Z$1:$Z$5,0)) <br><br>F9 <br> =INDEX(Numbers!$AB$1:$AB$5,MATCH(LARGE(Numbers!$AC$1:$AC$5,ROW()-3),Numbers!$AC$1:$AC$5,0)) <br><br>B10 <br> =INDEX(Numbers!$P$1:$P$5,MATCH(LARGE(Numbers!$Q$1:$Q$5,ROW()-3),Numbers!$Q$1:$Q$5,0)) <br><br>C10 <br> =INDEX(Numbers!$S$1:$S$5,MATCH(LARGE(Numbers!$T$1:$T$5,ROW()-3),Numbers!$T$1:$T$5,0)) <br><br>D10 <br> =INDEX(Numbers!$V$1:$V$5,MATCH(LARGE(Numbers!$W$1:$W$5,ROW()-3),Numbers!$W$1:$W$5,0)) <br><br>E10 <br> =INDEX(Numbers!$Y$1:$Y$5,MATCH(LARGE(Numbers!$Z$1:$Z$5,ROW()-3),Numbers!$Z$1:$Z$5,0)) <br><br>F10 <br> =INDEX(Numbers!$AB$1:$AB$5,MATCH(LARGE(Numbers!$AC$1:$AC$5,ROW()-3),Numbers!$AC$1:$AC$5,0)) <br><br>Row 7 is blank <br><br>Rows 1 & 8 has the letters that spell BINGO <br><br>These cells seem to be acting correctly <br><br>B2 <br> =INDEX(Numbers!$A$1:$A$5,MATCH(LARGE(Numbers!$B$1:$B$5,ROW()-1),Numbers!$B$1:$B$5,0)) <br><br>C2 <br> =INDEX(Numbers!$D$1:$D$5,MATCH(LARGE(Numbers!$E$1:$E$5,ROW()-1),Numbers!$E$1:$E$5,0)) <br><br>D2 <br> =INDEX(Numbers!$G$1:$G$5,MATCH(LARGE(Numbers!$H$1:$H$5,ROW()-1),Numbers!$H$1:$H$5,0)) <br><br>E2 <br> =INDEX(Numbers!$J$1:$J$5,MATCH(LARGE(Numbers!$K$1:$K$5,ROW()-1),Numbers!$K$1:$K$5,0)) <br><br>F2 <br> =INDEX(Numbers!$M$1:$M$5,MATCH(LARGE(Numbers!$N$1:$N$5,ROW()-1),Numbers!$N$1:$N$5,0)) <br><br>B3 <br> =INDEX(Numbers!$A$1:$A$5,MATCH(LARGE(Numbers!$B$1:$B$5,ROW()-1),Numbers!$B$1:$B$5,0)) <br><br>C3 <br> =INDEX(Numbers!$D$1:$D$5,MATCH(LARGE(Numbers!$E$1:$E$5,ROW()-1),Numbers!$E$1:$E$5,0)) <br><br>D3 <br> =INDEX(Numbers!$J$1:$J$5,MATCH(LARGE(Numbers!$K$1:$K$5,ROW()-1),Numbers!$K$1:$K$5,0)) <br><br>E3 <br> =INDEX(Numbers!$J$1:$J$5,MATCH(LARGE(Numbers!$K$1:$K$5,ROW()-1),Numbers!$K$1:$K$5,0)) <br><br>F3 <br> =INDEX(Numbers!$M$1:$M$5,MATCH(LARGE(Numbers!$N$1:$N$5,ROW()-1),Numbers!$N$1:$N$5,0))

0 |

5/2/2010 3:30:20 AM

This set up was originally for 75 numbers. In the second sheet there where (3) sets of 5 columns with 15 rows each. <br><br>I took and deleted the numbers from 26-75 <br><br>I then made 5 column of 5 rows each by cutting and pasting: <br><br>1	0.941481906		16	0.372377533		6	0.364931608		11	0.502122056		21	0.984256048 <br> 2	0.536584858		17	0.361460471		7	0.555143076		12	0.076269993		22	0.705505836 <br> 3	0.57106262		18	0.225019925		8	0.599454419		13	0.171432136		23	0.55615215 <br> 4	0.894617963		19	0.782584441		9	0.646271311		14	0.89659554		24	0.161401461 <br> 5	0.695414685		20	0.092296653		10	0.492237897		15	0.616963681		25	0.157171595 <br><br>1	0.193406672		6	0.958883039		11	0.318913906		16	0.545599863		21	0.667879587 <br> 2	0.803493655		7	0.581899116		12	0.542515461		17	0.682065422		22	0.483289631 <br> 3	0.708818348		8	0.221810767		13	0.799975414		18	0.084285534		23	0.104192029 <br> 4	0.830712719		9	0.675504324		14	0.33478638		19	0.932731846		24	0.991972791 <br> 5	0.544669395		10	0.694428477		15	0.112479015		20	0.691381364		25	0.965832338 <br><br>1	0.694738042		6	0.86595987		11	0.903419695		16	0.262463426		21	0.008170542 <br> 2	0.083745427		7	0.044931691		12	0.430510665		17	0.547232687		22	0.669368166 <br> 3	0.680413716		8	0.815642955		13	0.519759512		18	0.09317679		23	0.821925664 <br> 4	0.574002915		9	0.848216665		14	0.225085772		19	0.319883073		24	0.886122491 <br> 5	0.214044215		10	0.264216104		15	0.562006026		20	0.817634512		25	0.157414113

0 |

5/2/2010 3:36:53 AM

Yep: None of the cells feeding values into the formula can be blank. Change the formulas so they point to cells that contain valid values :-) If I were you, I would go back to the original and look to see which cells those formulas are supposed to be pointing to. Given that you have a LARGE within a Match within an Index, this is quite a complex formula. You may find that it helps to pull it to pieces and get each piece working, then plug them all together. Cheers On 2/05/10 1:30 PM, in article 59bb7bbc.3@webcrossing.JaKIaxP2ac0, "TomKC@officeformac.com" <TomKC@officeformac.com> wrote: > John, > > That makes total sense. The first group is B2-F2 thru B6-F6 (D4 is open) > > The next group is B9-F9 thru B13-F13 > > The last group is B16-F16 & B20-F20 > > In the second group I'm getting errors in these cell all the way thru the end > of the third group. > > When I select Trace error for example in B9 it shows a dotted line with a > small table symbol to D7 and on C9 it shows a similar dotted line to A7. Both > of which are blank cells. > > Thanks for any help. > > ============================================ > > This is cell B9 > =INDEX(Numbers!$P$1:$P$5,MATCH(LARGE(Numbers!$Q$1:$Q$5,ROW()-3),Numbers!$Q$1:$ > Q$5,0)) > > C9 > =INDEX(Numbers!$S$1:$S$1,MATCH(LARGE(Numbers!$T$1:$T$5,ROW()-3),Numbers!$T$1:$ > T$5,0)) > > D9 > =INDEX(Numbers!$V$1:$V$5,MATCH(LARGE(Numbers!$W$1:$W$5,ROW()-3),Numbers!$W$1:$ > W$5,0)) > > E9 > =INDEX(Numbers!$Y$1:$Y$5,MATCH(LARGE(Numbers!$Z$1:$Z$5,ROW()-3),Numbers!$Z$1:$ > Z$5,0)) > > F9 > =INDEX(Numbers!$AB$1:$AB$5,MATCH(LARGE(Numbers!$AC$1:$AC$5,ROW()-3),Numbers!$A > C$1:$AC$5,0)) > > B10 > =INDEX(Numbers!$P$1:$P$5,MATCH(LARGE(Numbers!$Q$1:$Q$5,ROW()-3),Numbers!$Q$1:$ > Q$5,0)) > > C10 > =INDEX(Numbers!$S$1:$S$5,MATCH(LARGE(Numbers!$T$1:$T$5,ROW()-3),Numbers!$T$1:$ > T$5,0)) > > D10 > =INDEX(Numbers!$V$1:$V$5,MATCH(LARGE(Numbers!$W$1:$W$5,ROW()-3),Numbers!$W$1:$ > W$5,0)) > > E10 > =INDEX(Numbers!$Y$1:$Y$5,MATCH(LARGE(Numbers!$Z$1:$Z$5,ROW()-3),Numbers!$Z$1:$ > Z$5,0)) > > F10 > =INDEX(Numbers!$AB$1:$AB$5,MATCH(LARGE(Numbers!$AC$1:$AC$5,ROW()-3),Numbers!$A > C$1:$AC$5,0)) > > Row 7 is blank > > Rows 1 & 8 has the letters that spell BINGO > > These cells seem to be acting correctly > > B2 > =INDEX(Numbers!$A$1:$A$5,MATCH(LARGE(Numbers!$B$1:$B$5,ROW()-1),Numbers!$B$1:$ > B$5,0)) > > C2 > =INDEX(Numbers!$D$1:$D$5,MATCH(LARGE(Numbers!$E$1:$E$5,ROW()-1),Numbers!$E$1:$ > E$5,0)) > > D2 > =INDEX(Numbers!$G$1:$G$5,MATCH(LARGE(Numbers!$H$1:$H$5,ROW()-1),Numbers!$H$1:$ > H$5,0)) > > E2 > =INDEX(Numbers!$J$1:$J$5,MATCH(LARGE(Numbers!$K$1:$K$5,ROW()-1),Numbers!$K$1:$ > K$5,0)) > > F2 > =INDEX(Numbers!$M$1:$M$5,MATCH(LARGE(Numbers!$N$1:$N$5,ROW()-1),Numbers!$N$1:$ > N$5,0)) > > B3 > =INDEX(Numbers!$A$1:$A$5,MATCH(LARGE(Numbers!$B$1:$B$5,ROW()-1),Numbers!$B$1:$ > B$5,0)) > > C3 > =INDEX(Numbers!$D$1:$D$5,MATCH(LARGE(Numbers!$E$1:$E$5,ROW()-1),Numbers!$E$1:$ > E$5,0)) > > D3 > =INDEX(Numbers!$J$1:$J$5,MATCH(LARGE(Numbers!$K$1:$K$5,ROW()-1),Numbers!$K$1:$ > K$5,0)) > > E3 > =INDEX(Numbers!$J$1:$J$5,MATCH(LARGE(Numbers!$K$1:$K$5,ROW()-1),Numbers!$K$1:$ > K$5,0)) > > F3 > =INDEX(Numbers!$M$1:$M$5,MATCH(LARGE(Numbers!$N$1:$N$5,ROW()-1),Numbers!$N$1:$ > N$5,0)) -- The email below is my business email -- Please do not email me about forum matters unless I ask you to; or unless you intend to pay! John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer, McGhie Information Engineering Pty Ltd Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:john@mcghie.name

0 |

5/2/2010 11:51:42 AM

How can I lock the fill colours in a row even when I change around the data or sort alphabetically? Thanks and God Bless, Harley Use CF http://www.cpearson.com/excel/banding.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Crowraine" <Crowraine@discussions.microsoft.com> wrote in message news:ED158D7D-62AB-4DA8-A948-2A6556D8047C@microsoft.com... > How can I lock the fill colours in a row even when I change around the data > or sort alphabetically? > > Thanks and God Bless, > Harley ...

Any help would be greatly appreciated. I am trying to group data together into increments of 10% of th numbers and then chart them based on these groups. For example, I hav 300 data points that vary from 20 to 500 in value. I want them t appear in a chart based on the number of values that fall in the lowes 10% of numbers (ie. 20-40) then the next 10% (ie. 40-60) etc. up to th top 10% of numbers, but I do not want to manually determine what thes ranges are. I want to see a distribution of how many numbers fal within each 10% of values. I am not sure if this makes sense, please let me know...

i ave a dropdown field on the first tab. I use setfocus so that it selects a different field to stop users scrolling down and changing the selection on the load event. Problem When a user changes tab and come back to the origional tab the setfocus doesnt run as the form is already loaded. How do you get around this? This is driving me and users mad at minute...please help before i open another bottle of dark rum! Hi Brian, Check out following URL; how to fire onclick event on tab click. It may help you. http://crmrocks.net/?p=16 -- PLEASE do click on Yes or No button if this post wa...

I am having problems restoring a backup money file from my cdrw disc. I recieve the error that it can't open possibly because it is a read only file or you do not have permission to change it or your disk drive is write protected. I have never had this problem before. I have restored files from my cd backup 3 times before without a problem. Please help!!!! Restore the file to writable media - your hard drive. If you still can't open it, right-click on the file in its new location, choose Properties from the context menu, and remove the check from the 'read-only' box. -...

I was helping the operations/it director to get RPC over HTTP going on their exchange server for a company I use to be the sys admin for. The ops/it director was doing the add/remove programs portion to add rpc over http there, somehow in the process of doing this he managed to uninstall IIS -or- just NNTP and SMTP (I can't figure out which and he claims he did neither). Long story short, I've reinstalled NNTP and SMTP, reconfigured SMTP to the best recollection I have of the previous config and the server still refuses to send/receive email, even internally. All services are s...

Please excuse the posting as I wasn't sure which group to post this in. I'm having issues using Outlook from a server desktop, an RDP or ICA connection. I have remote users who connect using Citrix. They logon to the Citrix server desktop (Windows 2003 Server) and use Outlook from there. They can also use Outlook from within Citrix as it is a Published Application. I know some of you are going to suggest why don't they use OWA but let's not get into that. I can log onto any workstation here in the office and connect to the Exchange server and open their Outlook. What I and they...

Can you do the title above in Publisher? Sure. I've done them in different label sizes. What size labels are you interested in? -- Don Vancouver, USA "Robert" <Robert@discussions.microsoft.com> wrote in message news:23DBCD56-027A-406F-B9D1-3EF45B8E33C0@microsoft.com... > Can you do the title above in Publisher? Thank you. I use the 2.5" x 1" size. it is a standard Avery Label size. "Don Schmidt" wrote: > Sure. I've done them in different label sizes. What size labels are you > interested in? > > > -- > Don > Van...

Hi. I hope someone is able to cast some light on a problem. We have a home network (all computers running XP) some wired and some wireless. For about a month now we have intermittent connection problems in that any one computer (randomly) will not connect to internet. I think all of the computers have suffered from the problem. Rebooting the affected computer makes no difference but rebooting the router can sort it until the next time. Even my mobile phone occasionally cannot connect. In Firefox the message is just "server not found". Pinging an IP address results in a time...

Hi I've been having issues getting Public Folder replication going between 2 Exchange 2003 servers. Prior to doing any work I performed a Backup using Veritas Backup Exec and this completed and verified correctly. I screwed things up and managed to delete some of the public folders on my original server. I'm not 100% sure what I did but it is a mess and the only backup I have is the Exchange backup I created before doing any work. The public folders contain a number of Contact Lists and a very important Event Calendar. I have restored the public folders but when the restore c...

Hi: Hoping that someone can offer a suggestion on this one. I'd like to be able to synchronize an email folder in a particular users' Outlook account with a public folder. The idea is to have email conversation threads in a particular folder (just one folder) visible to others in the group via the public folders. Ideally, it would be great if changes to the public folder are instantly mirrored in the users folder - but that requirement is not critical, the core requirement is to have the public folder mirror the user's folder (in real time). I know that I could accomplis...

I need a formula to calculate the following information please: I will have someone enter a time (ex 6:31) in cell C3. If the time matches one of the times in cells B17-B22 I need it to display 4.6, if it matched one of the times in cells B23-28 I need it to display 4.7, if it matches one of the times in cells B29-34 I need it to display 4.8 and so on. Does anyone have a simple formula I can do for this please? =IF(COUNTIF(B17:B22,C3)>0,4.6,IF(COUNTIF(B23:B28,C3)>0,4.7,IF(COUNTIF(B29:B34,C3)>0,4.8,"no match"))) Can't do the "and so on" part, bu...

Hello Gurus, Currently I am having an issue with logins and profiles as per details below. Server/Network Configuration Details: 1 X Windows Server 2008 Std FE 64bit (DC) 2 X Windows Server 2008 Ent 32bit Terminal Servers User Profiles are Roaming and exist in: \\SBSERVER\Profiles on the Domain Controller and C:\Users\ on the Terminal Servers. Approx 50 users. Problem Description Error messages when logging in the terminal servers: Your roaming profile is not synchronized correctly with the server. Windows will load your previously-saved local profile instead. See the pre...

For reasons I don't understand, MS saw fit in RMS 2.0 to use dimensions data for matrix components that is far less accessible to users than Sub Descriptions are. For instance, I can't edit assign a dimension value to an existing item I have added to a matrix. I can't see a reason for using Dimensions with limitations like this as using Sub Descs. to describe matrix "dimensions" worked fine previously. Does anyone know why MS did this? It's annoying! Digital Retail Solutions (DRS) has a product called Power Ops (Build 2.2.0003). It's help file mentions (se...

anyone know if RMS works with membership and discount cards? I would like to offer that to my customers and have them accrue rebates. Best, M Depends on the card and exactly what kind of membership program you want to offer. If you create membership cards with a barcode for the customer account number, and simply want to offer discount levels, you can get good functionality right out of RMS. If you want to offer rewards based on points, or use magnetic membership cards, it gets much more complicated and you're going to need an add-in. Talk to your RMS Reseller about your needs, ...

I am setting up a basic excel spreadsheet and really have got no experience with excel. I want to do something real basic like if A2=laptop display $10 or if A2=desktop display $20 how do I do this? I think that if the list of options is more than a just a few, a =vlookup() function would work nicely. It may seem a little complex to start, but once you use it, you'll find tons of more reasons to use it. Debra Dalgleish has some nice instructions at: http://contextures.com/xlFunctions02.html BadSector wrote: > > I am setting up a basic excel spreadsheet and really have got no...

I have to keep restarting my computer to be able to open Word or Entourage. The icons just bounce a little but won't open. I was getting a request from Entourage to rebuild the database which I did about 6 or 7 times. I got another warning which I ignored. I am on a MacBook Pro (Intel based). I am using office 2004. My Entourage database is 3.2 gb. I ran Disk Utilities a couple of times. I also had a problem a couple of times with FileMaker Pro but not sure if related. Thanks Christina On 22/8/06 20:01, in article 1156273266.788654.318170@i42g2000cwa.googlegroups.com, "...

I have these code and it works find: but i also want to use it for different culumn within the same sheet. how do i add Column D with different target? meaning "S" for Study and "B" for books and s on... and maybe adding a Msg box to it that will only allow the Letters specify.. thank you in advance.. Private Sub Worksheet_Change(ByVal Target As Range) If Target = "" Then Exit Sub If Target.Count > 1 Then Exit Sub If Not Intersect(Target, Range("c6:c50")) Is Nothing Then If UCase(Target) = "C" Then Target = "Contribution" El...

GP ITEM PRICING I need to use “Bucket Pricing” for items in GP. For example below is the pricing schedule that I need to use. First 20 …………….$ 1.75 Next 280 ……………… 1.36 Next 700 ……………… 1.23 Next 2,000 ……………… 1.09 Over 3,000 ……………… .82 So if I had a Qty. of 350 it would be as follows 20 * 1.75 = 35 280 * 1.36 = 380.80 50 * 1.23 = 61.50 Total : $477.30 In GP I can only set it up to do a “Quantity Range” in the Item Price List Maintenance window. Problem is if I set it up that way and enter a quantity of 350 it will default to the $1.23 ...

Hello. Sorry to ask such a simple question, but I need help on how to get a total of some cells. Here's the sample. If cell A1 is 05 and is true A3 is 10 and is true A5 is 15 and is False A7 is 10 and is True A9 is 05 and is False How can I make A11 show me the result by just adding those numbers that are TRUE and give me the sum ? Would really like help, thank you. Hi Mike! I assume that you have TRUE or FALSE as boolean in an adjacent cell. If so: =SUMIF(B1:B9,"=TRUE",A1:A9) But the assumption may be wrong and you'll need to provide more information. -- Regard...

thanks for the help !!!!!!!! It worke -- cbender ----------------------------------------------------------------------- cbender3's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1556 View this thread: http://www.excelforum.com/showthread.php?threadid=27126 ...

I have a new computer and my outlook 2003 is not letting me assign a default account to send and receive. I get this error: "The Specicied Account could not be found. It might have been deleted." I have four accounnts setup and have tried removing the accounts and recreating them and still get the error. when the account has been made, it tests fine. None of the four can be made default. Thanks in Advance! ...

I am setting up a MS CRM system for a pilot which focus primarily on our sales department. I have given each user who's a salesperson given a quota in the CRM system. These numbers are confidential and so not everybody may be given the possibility to view this data. But when I checked with another role, I could see the quota of erverybody who's got quota assigned. Is there a possibility to make these quota's only visible to the persons I want (for example the director can see the quota's of everybody, the salespersons can only see the quota for themselves and the rest o...

Greetings. I have a chart which can go from x-value 0 to x-value 200. However I'd like to be able to input min X-value into a cell, and a max X-valu into a cell, and the x-value in the chart changes to reflect that. Is it possible to do that? Thanks for any replies. K -- Message posted from http://www.ExcelForum.com Hi, There is no automatic way to do this but take a look a Tushar's AutoChart Manager for a possible solution. (http://www.tushar-mehta.com/) Cheers Andy Kashgarinn < wrote: > Greetings. > > I have a chart which can go from x-value 0 to x-value 200...

To make a brochure, I open up Publisher, go to 'Publications for Print' -> 'Brochures'. No matter which design I select, about 5 seconds after the 'Changing your Publication' window comes up, another window pops up telling me 'Publisher cannot complete the operation'. This only happens for brochures - all other publications work. Does anyone have the answer? Try a detect and repair in the Help menu. Do a disk clean-up. Don't delete the Office setup files if you do the disk clean-up. The clean-up is found by right clicking your hard drive, propertie...

I just came onto a project and got a 1700 line project plan from the previous 4 project managers. Q. Is it normal for tasks with unassigned ? empty resources to show that task in the Resource Usage window? And then on the Gantt View, when I add a resource under that column, it then shows up on the Task line as a Task! I've never seen this happen before. Any ideas?????? J > > Q. Is it normal for tasks with unassigned ? empty resources to show > that task in the Resource Usage window? > Sure - it shows up under the "Unassigned" label. &...