Ned

Members
  • Content count

    19,273
  • Joined

  • Last visited

  • Days Won

    2

Ned last won the day on September 6 2015

Ned had the most liked content!

Community Reputation

6,533 Excellent

About Ned

Contact Methods

  • AIM
    jake3178
  • Website URL
    http://
  • ICQ
    0

Profile Information

  • Gender
    Male
  • Interests
    fantasy football dominatrix; punking AAABatteries

Previous Fields

  • Favorite NFL Team
    New England Patriots
  1. Looks like he wasn’t part of the 18 after all.
  2. These memos are dumb and waters down the fact that regardless of why they found the suspicious activity, the courts still found the activity suspicious enough to grant the FISA warrant. Why any of this “politically motivated dirt” is “SO ILLEGAL” escapes me.
  3. Looks like Keaton Parks made the 18 today for Benfica.
  4. My god I remember that and wondered if/when it’d resurface.
  5. You have been one of the most impressive posters here. I appreciate the info you’ve taken the time to share here. Seriously.
  6. I'd think a macro would be the best bet. Here's a quick and dirty that'll scan a tab for all linked cells and list them out on a new tab. It assumes the data is in a neat/clean table with no breaks (blanks) in the rows/columns. Just click on the upper left cell in the data and run the macro... It's hard to write these things blind, so take it FWIW. Sub Find_All_Links() Dim SrchRng As Range, SrchCell As Range, NewTab As String, CurrTab As String Application.ScreenUpdating = False CurrTab = ActiveSheet.Name Set SrchRng = Range(Selection, ActiveCell.SpecialCells(xlLastCell)) For Each SrchCell In SrchRng If InStr(SrchCell.Formula, "[") > 0 Then If NewTab = vbNullString Then Sheets.Add After:=ActiveSheet NewTab = ActiveSheet.Name Columns("A:B").NumberFormat = "@" Sheets(CurrTab).Select End If Sheets(NewTab).Cells(Rows.Count, 1).End(xlUp).Offset(1, 0) = SrchCell.Address Sheets(NewTab).Cells(Rows.Count, 2).End(xlUp).Offset(1, 0) = SrchCell.Formula End If Next SrchCell End Sub
  7. Those blue collars And didn't his momma ever teach him to not use his teeth to untie his shoes?
  8. What are you looking to do when you find the links?
  9. Do a find for [ and tell it to search the entire workbook.
  10. What if its =7? The below will do exactly what you posted above, but 7 will fall through the cracks. =IF(A1<1,"S",IF(AND(A1>1,A1<7),"Y",IF(AND(A1>7,A1<31),"Z","MORE CONDITIONS"))) If you want to add more conditions, just copy/paste this over the "MORE CONDITIONS" (including the quotation marks) in the above and change the conditions in red and results in green as needed. IF(AND(A1>99,A1<99),"AA","MORE CONDITIONS")
  11. Trump: maybe we should have movie ratings