addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwchatcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobegmailgoogleimageimagesinstagramlinklocation-pinmagnifying-glassmailminusmoremuplabelShape 3 + Rectangle 1outlookpersonplusprice-ribbonImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruseryahoo

Be ready to talk about Excel and take notes!

Hi all, welcome to the MS Excel Refresher Meetup Group.  Our next Meetup is scheduled for Thursday, February 7th at 6:30PM at the Ansir Innovation Center. The February Meetup will focus on Vlookup formulas, Pivot Tables and of course your personal questions.

Be ready to take notes on the many tips and tricks that will be shared by your host and fellow members. Computers will not be available on-site so it is preferable that you bring your own laptop, but by no means is it required.

I'm looking forward to seeing everyone and helping to make 2013 the most productive year yet!

Please let me know of any questions that you may have, thank you!

 

Join or login to comment.

  • Jake K.

    Hi everyone. Here is the link to last night's puzzler: http://chandoo.org/wp/2011/03/09/ec1-machine-scheduling-in-excel/

    Let us know if you come up with anything!

    1 · September 10, 2013

  • Excel G.

    Good morning gang. I came up with a solution when I was driving home last night. I was on the right track with my "COUNTIF" approach. I tested it when I got home and produced a working model. So if you downloaded the sheet, place the following formula in cell F4:
    =IF(OR(COUNTIF(D4:D9,E4),(COUNTIF(E4:E9,D4))),C4&" OVERLAPS","OK")

    Enjoy!

    September 10, 2013

    • Excel G.

      Sadly its not a full proof working model. I had a chance to test it by adding more lines and it fails... It works for the example, but not for additional overlapping date ranges. Oh well, back to the drawing board. Hope you guys have better luck :)

      September 10, 2013

  • Louis B.

    Was anyone able to assist the person on our LinkedIn group a few weeks ago asking about a problem with her list of names on one worksheet and the desire to remove the name from the first if it was used in the second?

    September 4, 2013

    • Louis B.

      Hi Sony,
      I don't know what is wrong with this system, but everytime I hit enter to drop a line, it closes the reply.

      Apparently she did not leave it on our site, as I suggested at the time I made the announcement, but this is what she asked on Exel and Access Novice and Expert Users:

      Can anyone provide some help with a logical formula?
      Sonya Weaver
      Administrative Assistant III

      I have two worksheets, on Worksheet #1 I have 9 columns that each contain a list of names. On worksheet #2, I have blank cells. When a name from the list is entered in that column, I would like for the name listed on worksheet #1 to be removed ...
      Like Comment (5)Unfollow21 days ago
      See all 5 comments
      Paul Bunting
      Paul Bunting In VBA (Alt-F11), in "Sheet2", place the following code: ...
      16 days ago
      Ray Bomben, CMA
      Ray Bomben, CMA In worksheet 1 use a countif function ...
      15 days ago
      winston snyder
      winston snyd

      September 4, 2013

    • Excel G.

      Thanks Louis. I'm not able to view that group since it's locked by the owner. Can you tell if it has been solved for Sonya? Thanks!

      September 5, 2013

7 went

Our Sponsors

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy