Question about Microsoft Computers & Internet

1 Answer

For March in date column A2:A500 how many text entries in J2:J500

For a particular month in a column of dates how many entries made in corresponding rows in another column? - P. Michael

Posted by on

  • pmichael674 Apr 23, 2009

    I do appreciate your suggestion. I did some coding with VB. Now I am not using it due to corcumstances. May I have a solution in MS Excel.

    Thanks for your concern.

    -P. Michael

×

Ad

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Expert
  • 289 Answers

With VBA, you can write code to "loop" through that range of cells (A2:A500) and keep a count when the date is in March. With each iteration of your loop, test the value in the cell. Do the same for the other column. If this is not clear or I've misunderstood, please post back and we'll work on it more...

Posted on Apr 23, 2009

  • Fred Block
    Fred Block Apr 23, 2009

    Sorry - but not sure of a way outside of custom coding for your need.

×

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of.(from cars to computers, handyman, and even drones)
click here to download the app (for users in the US for now) and get all the help you need.
Goodluck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

I'm traveling to Spain 11 th march till 19th march, my passport expires 10th April, is this ok.? Or do I need 3 months on my pasport?


Some countries require as much as 6 months remaining on your passport for entry. Spain appears to Require at least 3 months remaining after your travel date. I suggest that you need to apply for an expedited passport renewal and pay the added fee for that service if you need to maintain your stated travel dates. see Spain

Feb 08, 2017 | Passport Computers & Internet

2 Answers

Ultima washing machine reads test in the window


Hi from retired Englishman in SW France,

I read your other entry first ;-0)
You will have to find the date code- on the rear panel perhaps- then here are your options-

Date code 39 March 2005
Press start/cancel until ALL LEDS are lit
Press both start/cancel AND on/off together until 'dOFF' is displayed

Date code 39 March 2005 to date code 42 June 2005
Press the cancel button and the machine should return to normal

Date code 43 July 2005 onwards
Press both star/cancel AND on/off TOGETHER with top left option button until 'dOFF' is displayed.

Good luck!
John C

Mar 16, 2011 | Hotpoint Aquarius WMA42 Front Load Washer

1 Answer

How do I determine the year my GE model TFX24R was made?


Print How to Determine the Age or Manufacture Date of a GE Appliance

The manufacturing date and year is coded into the serial number of the appliance. Our serial numbers begin with two letters. The first letter identifies the month and the second letter identifies the year. The corresponding letters, months, and years are below. For example, if the serial number begins with the letters "FJ," the appliance was made in March of 1952.

Letter Month (first letter) Years (second letter) A January 2001, 1989, 1977, 1944 B -- 1945 C -- 1946 D February 2002, 1990, 1978, 1947 E -- 1969, 1948 F March 2003, 1991, 1979, 1949 G April 2004, 1992, 1980, 1950 H May 2005, 1993, 1981, 1951 J -- 1952 K -- 1953 L June 2006, 1994, 1982, 1970, 1954 M July 2007, 1995, 1983, 1971, 1955 N -- 1972, 1956 P -- 1973, 1957 R August 2008, 1996, 1984, 1958 S September 2009, 1997, 1985, 1959 T October 2010, 1998, 1986, 1974, 1960 V November 1999, 1987, 1975 Z December 2000, 1988, 1976 AY -- 1965 BZ -- 1966 CA -- 1967 DB -- 1968 VU -- 1961 WV -- 1962 XW -- 1963 YX -- 1964

Aug 18, 2010 | Refrigerators

1 Answer

Setting up date and time


Hi,

Please check the date display format

In your mobile it might have set to this format

MM DD YYYY

So as the first column is in months as you enter 24 it doesnt accept and shows 02 ,This is because you have only 12 months in a year.

So please type month date and year.

If you want you can change the format to DD MM YYYY in date and time setting option.

Thanx


Thanx

Jul 24, 2010 | LG KP500 Cookie black on T-Mobile U-Fix...

2 Answers

Need to have a certain cell say OFF when it is a certain day


Use the test function.
Formula in cell A1 would be =text(a2,"dddd").
This would pick up the date from cell A2 and return the day of the week in cell A1.

Jun 06, 2010 | Microsoft Excel for PC

1 Answer

I copied the following: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cells.Count > 1 Then Exit Sub If Not Intersect(Target, Range(''A2:A100'')) Is Nothing Then With...


This will fix you up. You can just use the date stamp or the date and time stamp.

1 2 3 A B Formula Description (Result) =TODAY() Current date (varies) =NOW() Current date and time (varies)

Aug 23, 2009 | Microsoft Excel for PC

1 Answer

I need to change the time on my Sharp EL-1750PIII calculator


You can access the .pdf manual for your particular calculator here:

http://www.sharpusa.com/files/cal_man_EL1750PIII.pdf

Page 1 for how to set date/time:

“RATE SET”: To set the date, time, and tax rate, set this switch at the “RATE SET” position.
Date:
• Enter in the order of month, day and year, then press to complete the entry.
• Use to separate month, day, and year.
• When is pressed, the number entered is evaluated and displayed as “date” if the
value is within the following range; “Error” is displayed otherwise, and the previously set
date is restored.
Month: 1 - 12; day: 1 - 31; Year: 2000 - 2099 (in 4 digits) or 00 - 99 (in 2 digits)
Time:
• Enter in the order of hour, minutes, then press to complete the entry.
(There is no entry available for the seconds value. The clock starts at zero second.)
• If the hour/minute digit is less than 10, it is not necessary to enter the first digit “0”.
• Use to separate hour and minute values.
• When is pressed, the number entered is evaluated and displayed as “time” if the
value is within the following range; “Error” is displayed otherwise, and the previously set
time is restored.
Hour: 0 - 23 (24-hour system for the hour entry), Minute: 0 - 59

Apr 27, 2009 | Sharp EL-1750PIII Calculator

1 Answer

Zenith Redi_set clock radio Z230S


Describe your problem: Depress MONTH/DATE and ALARM1 for 3 seconds and display will show DST 'start' month,week,and date.
Display will show 4F 4.1, alternately flashing

4F = April First week. 4.1 = April 1.That is the old dates for change. What we want to do is to change to the new dates. Once it is done, it will change in the new dates as it did on the
old dates..

Hold down the MONTH/DATE button for 5 seconds, and while pressing the - or down button3 times, until the display shows '3'F2.
3 is month F2 is the week.
=March 2nd week.
You have successfully change the March changeover.

Now for the November change.
Depress and hold MONTH/DATE and ALARM2 after 3 second the display will show DST 'end' month,week, and date.
First digit will be 10 =month. second digit will be L=Last week, and date, will flash alternately.
While holding down the MONTH/DATE press the + or UP button once the display will show 11 (November) and F (first week) and 1 as date alternately flashing.
You have successfully set it for the next 100 years

Apr 17, 2009 | Zenith Z230S Clock Radio

2 Answers

Formula for calculating the days beween months


for example, cell A1 has date (01-01-2008) and cell A2 has current date (08-24-2008) and cell A3 shows total days, is that you want to know? if yes, apply formula as under...

cell A3......(properties set as General to show digits)................ =SUM(A2-A1)

Aug 25, 2008 | Microsoft Office Professional 2007:...

1 Answer

Unable to Change Dates


Hi,
I am using MS-2007, i got the solution upto some level only.
i can't say exactly whether it is right or not.
my solution is :

first change the settings in ControlPanel/Regional and Language Options.
Click on Customize button/open the Date Tab and set the date format there.
and then proceed with CSV.
Open CSV in Excel and divide Text to coloumns.
Ur all Date Cells will be in particual Format.
and Select that coloumns and right click Format Celss....etc.
Thanking u.

If u found any Douts, Suggestions ,Plzz let me know.

Jun 27, 2008 | Excel (SS8SATAS5128400R)

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

68 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2855 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18402 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...