Page 2 of 2 FirstFirst 1 2
Results 11 to 14 of 14

Thread: Excel Table with IF & Vlookup function Formula Config

  1. #11


    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi! Our study would like to track all bills that were re-filed by our lawmakers from the previous congress to the present congress.

    Historically, when our lawmakers are re-elected, they just re-file their bills with the exact titles. In order for us to quantify the magnitude or the rate of refiled bills, we would like to look at the exact phrasing or string of titles that were filed in the current congress based on the titles that were recorded in the previous congress.

    Suppose our lawmaker filed a bill "Renaming Santiago School into Dawson School" in the last Congress. When this was signed into law and that lawmaker was reelected, he again re-filed the bill with same title. This is what we are tryoing to

  2. #12
    Suppose our lawmaker filed a bill with a title "Renaming Santiago School into Dawson School" in the last Congress. When this bill was not signed into law and this lawmaker was again re-elected, he would re-filed this bill with the same title. This is where we are tying to track how many of his bills filed in the current congress were rehashed.

    In many instances, lawmakers file new bills in the present congress, so it is hard for us to track the bills which are considered refiled since our lawmakers file bills more 30 roughly. From these, sometimes there are 10 bills which are rehashed. Our problem is that more than 100 lawmakers get to be re-elected, historically speaking. And we would to look at at least 8 Congresses with more 100 re-elected lawmakers who author more than 30 bills. So it's quite a daunting task. I would like share our excel files if you like.

  3. #13
    i would be happy to look at your files(s) to see what i might be able to do. I sent you a PM with my email if you don't want to post them on the forum

  4. #14
    Hi, Tommy! I can't seem to find your PM. I'm using my phone in replying to you. Can you email me so I can email the dataset? Email me at alliage.morales[at]gmail.com I will wait for your email. Thank you very much!

Page 2 of 2 FirstFirst 1 2

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •