Thread: CountIf formula

Compare the workbook options of both workbooks under ToolsOptionsCalculation '1904 date system' -- Jacob "Nathan" wrote: I copy a date cell (let's say 12/9/09) from one spreadsheet and when I paste it into another spreadsheet, it goes to 12/9/13. What!? Any clue as to why it would be adding 4 years to the date?

Unprotect then re-protect. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim Data As Range Dim i As Integer Dim j As Integer Dim k As Integer Dim aq As Integer i = 2 j = 34 k = ActiveCell.Column() aq = ActiveCell.Column() Set Data = Range("B6:AH259, AH6:BA259") If Application.CutCopyMode = 0 Then ActiveSheet.Unprotect Password:="justme" 'edit pword to suit Data.Interior.ColorIndex =...

If you're sure you're not looking at formulas, then reformat the cell as General and reenter the formula--selecting the cell, hitting F2, then enter should be enough. Saved from a previous post. Excel likes to help. Try this on a test worksheet. Select A1 and hit ctrl-; (to put the date in the cell) now select B1 and type: =a1 Notice that excel changed the format of B1 to match the format in A1. Now format D1 as Text. put ASDF in D1...

Don't put it in A1, as that's what gives a circular reference; put it in another cell. -- David Biddulph "Phil-T" wrote in message ... If I clicked on A1, and typed any of the functions shown below, it just created a circular reference and blanked out the entire cell rather than just eliminating the leading apostrophe. "Ms-Exl-Learner" wrote: All the below function will clear the leading...

You're welcome. Thanks for the feedback! -- Biff Microsoft Excel MVP "Saylindara" wrote in message ... Thank you for your very quick and helpful response. "T. Valko" wrote: Are there DATES in this range: [Referrals10.xls]Referrals!$J$4:$J$250 Are you wanting to compare the month of the date in [Referrals10.xls]Referrals!$J$4:$J$250 to the month of the date in B2? If so, then this is incorrect:...

From my tests, this formula appears to work. You may need to adjust the range sizes inside the SUMPRODUCT function to meet your actual data: =SUM(OFFSET('Sales Data'!$B$1,SUMPRODUCT(--('Sales Data'!$A$2:$A$25=B2),--('Sales Data'!$B$2:$B$25=C2),ROW($B$2:$B$25))-1,MATCH(D2,'Sales Data'!$C$1:$Z$1),,COUNTIF('Sales Data'!$C$1:$Z$1,"="&D2)-COUNTIF('Sales...

Hi, I don't believe that is possible to do as a format. Mike "Nelson B." wrote: Thanks for the help. This works, but I was hoping to be able to simply change the format of a cell, so an input of 80 sec would show as 01:20. Is that possible or does it require the use of a formula? "Mike H" wrote: Hi, I assume these 'seconds' are simply numbers so try this =A1/(60*60*24) Format as [mm]:ss Mike...

Well, it is to do with your printer driver. Are you sure that the printer supports that paper size? Perhaps you can see if there is an updated driver for the printer. Hope this helps. Pete On Dec 14, 2:26*pm, Michele wrote: I've tried print option to set up 8.5 x 14 paper put it wont hold the setting. *

The reason for suggesting the paste special is your post seems that you are not familiar of using the formula's. That is the reason I skipped to an another alternate solution. Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "Irishrich" wrote: Type formula in B1 referencing A1 which will return your values in column B. To get a clean column of raw data highlight...

* Select all(!) 2000 cells. * Declare "Conditional Format" as per "Formula" =COUNTIF($C$1:C1,C1)1 * declare some background color i order to identify the duplicate names. *** This method will color from the second name and will not touch the first one. Micky "John" wrote: Is there a simple macro/VBA for checking a specific column in which there are random duplicate text entries? I do not...