http://help.wugnet.com/office/Worksheet-Functions-forum-42.html Top 15 Messages on help.wugnet.com http://help.wugnet.com/office/Validation-Employee-Timesheet-ftopict1180516.html#3731154 By: JLatham - Well, I don't know about eliminating all possible error entries since humans seem to have an almost infinite capacity for screwing up a typed entry, but... This code will test entries and replace commas and colons with a period which should help most of the time. To put the code to work, open your workbook, go to the time entering sheet and right-click on its name tab an... http://help.wugnet.com/office/Converting-standard-time-military-time-ftopict1180508.html#3731146 By: CellShocked - On Fri, 20 Nov 2009 10:49:40 -0800 (PST), "C." wrote: >On Nov 20, 1:18pm, "Joe User" wrote: >> "C." wrote: >> > I do have two different types of dates: >> > Sep 1 2009 4:45PM >> > and >> > Sep 18 2009 11:15AM >> > [....] >> > I tried your second suggestion in a parallel >> > column "=--SUBSTITUTE(A1, " ", ", ", 2)" but >> ... http://help.wugnet.com/office/Statement-ftopict1180511.html#3731121 By: Luke M - The way you wrote that, you are overwriting the date/date that was already in the A column with new information? Is that really what you want? I will assume that you actually want the new information in B column. In B18: =IF(A18=D$3,"Effective Date","Not Effective") Guessing again, you might want: =IF(A18<=D$3,"Effective Date","Not Effective") if you actually are che... http://help.wugnet.com/office/insert-picture-statement-ftopict1109377.html#3731096 By: mahir ibrahim - Hi, I have 3 pictures but only want to display one dependant on what infomation is in cell a1 is this possible using a IF statement?? nivek0 wrote: can i insert a picture with a if statement 02-Jun-08 I have 2 pictures but only want to display one dependant on what infomation is in cell a1 is this possible using a IF statement?? Previous Posts In This Th... http://help.wugnet.com/office/link-cells-excel-ftopict662820.html#3731046 By: mfk - I had to "enter" to make the information show on target sheet in workbook! "David Billigmeier" wrote: > Type an equals sign in the cell you want the information to end up in, click > over to another worksheet, and click on the cell you want to reference. > Excel will automatically enter it in. > > -- > Regards, > Dave > > > "stb" wrote: > > > I want to link th... http://help.wugnet.com/office/SEPERATE-POSITIVE-NEGATIVE-VALUES-COLUMN-ftopict1180488.html#3731041 By: Peo Sjoblom - Use autofilter, first filter custom and select greater than or equal 0, select and copy and paste into positive column, change to less than 0 and repeat for the negative values -- Regards, Peo Sjoblom "FRANK" wrote in message news:2B328BD5-0E47-4542-A6E5-EC2D5CAEFA15@microsoft.com... >I HAVE A COLUMN OF FIGURES I WISH... http://help.wugnet.com/office/doesnt-work-ftopict1180486.html#3731037 By: Jacob Skaria - Except that you can specify operators > = along with the criteria you cannot format the values or specify conditions within SUMIF() If this post helps click Yes --------------- Jacob Skaria "MurrayBarn" wrote: > I have two sheets. The one called CorpClaims and one called Summary, the > latter is where I want the answer. On CorpClaims is a list of data w... http://help.wugnet.com/office/Advanced-Filter-ftopict1180338.html#3731021 By: MeowSayTongue - On Tue, 17 Nov 2009 17:44:33 -0800, Pieyed Piper wrote: >On Tue, 17 Nov 2009 11:04:11 -0800 (PST), Herbert Seidenberg > wrote: > >>All routine operations >>Zzzz....Zzzz... > > So, why will the button macro let me place Table4 on another sheet, but >the always running macro will not? Also... http://help.wugnet.com/office/display-results-summation-format-ftopict1180482.html#3731019 By: Jacob Skaria - To handle just decimals ie; to display .563 as 0.56 and not as .56 try the below ="Total = "& TEXT(SUM(A1:A12),"#,##0.00") If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: > Try the below. > > ="Total = "& TEXT(SUM(A1:A12),"#,##.00") > > If this post helps click Yes > --------------- > Jacob Skaria > > > "Nh2" wrot... http://help.wugnet.com/office/OFFICE-ftopict1180371.html#3731016 By: Rij_racer - Hi Troy, Thanks for posting your response - that was so helpful to me. I recently imported data from Excel into Access and the dates changed to 5-digit numbers. I had no idea how to sort it out and all the information online seems to relate to converting 6-digit numbers. Your tip really did the trick. Many thanks. R "TroyT" wrote: > The dates might have been sa... http://help.wugnet.com/office/Conditional-Multiple-Time-Ranges-ftopict1180474.html#3731000 By: Ashish Mathur - Hi, Type the text in a cell (say A5) and colour the font to white (the text should not be visible). Then apply the following conditional formatting rule to the cell - Formula is =and(mod(now(),1)=time(8,0,0)). Apply the font to colour black Now when you refresh the pivot, the conditional formatting should apply -- Regards, ... http://help.wugnet.com/office/Comparing-values-charts-ftopict1180475.html#3730999 By: Mr BT - Thank you in advance for your assistance. I and trying to create a tool I can use to grade class assignments; one in particular uses charts. The class assignment the students are responsible for handing in will be one Excel file. I was hoping there was a way to sort of "extract" certain field values from the charts properties as well as the header/footer properties. If I ... http://help.wugnet.com/office/COUNTIF-FORMULA-ISSUES-FORMULA-CORRECTED-ftopict1180449.html#3730936 By: T. Valko - Try this (all on one line)... =SUMPRODUCT(--('FP Export data'!$G$2:$G$11000="Help Desk"), --('FP Export data'!$B$2:$B$11000=1)) Better to use cells to hold the criteria... I2 = Help Desk J2 = 1 =SUMPRODUCT(--('FP Export data'!$G$2:$G$11000=I2), --('FP Export data'!$B$2:$B$11000=J2)) -- Biff Microsoft Excel MVP "Debbi" wr... http://help.wugnet.com/office/Inserting-cell-function-ftopict1180445.html#3730930 By: Ashish Mathur - Hi, Read up on the VLOOKUP function in the Help menu -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "liamellis91" wrote in message news:1D601DA0-1820-4B02-92F6-5CE517DFB8A6@microsoft.com... > I want to do something that confuses me to explain, but I'll give it a go. > > I need to be able to inse... http://help.wugnet.com/office/turn-side-side-excel-ftopict1180442.html#3730920 By: Gord Dibben - Window>Compare side by side with is grayed out? If one or both of the workbooks are protected for structure and windows you cannot use the side by side feature. Gord Dibben MS Excel MVP On Tue, 17 Nov 2009 12:28:11 -0800, R Kaleta wrote: >i am comparing 2 large worksheets and i need to turn on the view side by side >featu... http://help.wugnet.com/office/roundup-rounddown-ftopict1180437.html#3730894 By: Bernie Deitrick - =ROUND(A2,0)-0.1 HTH, Bernie MS Excel MVP "Office Buddy" wrote in message news:11309675-8465-435C-87C5-D9C2344F9A81@microsoft.com... >I am working with currency figures and require each total to roundup to the > nearest .9 if the figure is for example 10.68 and to rounddown to the nearest > .9 IF it is less than .5 (f...