Favorite team:LSU 
Location:
Biography:
Interests:
Occupation:
Number of Posts:9370
Registered on:8/18/2004
Online Status:Not Online

Recent Posts

Message
re: Excel help request - GeneralLee
[quote]And OP, for that big of a dB, you should be using Tableau or something to present the data. [/quote] Agreed. This is for a side business of mine I'm starting up. If the business takes off and people sign up for it, i'll get the whole Excel file transformed into a database/website. But, ...
Posted on O-T Lounge
Jump to Post - View Topic - Replies (0)
re: Excel help request - GeneralLee
[quote]Assume these are in A1, A2, ... ,A5 B1 formula would be =IF(A2=“”,B1,””) Then copy down.[/quote] Yep, I have ~400 columns of numeric values that I'm using the vlookup function for, and then ~5 columns of text that I'm going to use the nested IF's formulas for. ...
Posted on O-T Lounge
Jump to Post - View Topic - Replies (0)
re: Excel help request - GeneralLee
[quote]Sounds like two things happened You boxed yourself into a corner or You had something going and you are now trying to expand it to something that your original spreadsheet wasn't intended for [/quote] Very close. I'm converting an Excel file into a website, but the website is muc...
Posted on O-T Lounge
Jump to Post - View Topic - Replies (1)
re: Excel help request - GeneralLee
My beginning month is February 2020, and I'm going out to December 2025 as that's the last month going out five years, finishing out the last year. But if my beginning month was November 2020, to get to December 2025 would be earlier up in the spreadsheet and I'd have 9 more rows of blank data to s...
Posted on O-T Lounge
Jump to Post - View Topic - Replies (2)
re: Excel help request - GeneralLee
Sorry man, it's a beast of a file and I didn't do a good job explaining it in English, my bad. I think the vlookup function will work for the numeric columns, and the text columns are so few that I can just do twelve "If" formulas in each cell to pull the last text value....
Posted on O-T Lounge
Jump to Post - View Topic - Replies (1)
re: Excel help request - GeneralLee
Looks like vlookup(9.99999999999999E+307 (i.e. a massive number, array,1) is my best option for the columns with numbers. Still noodling on how to come up with formula for columns with text....
Posted on O-T Lounge
Jump to Post - View Topic - Replies (0)
re: Excel help request - GeneralLee
[quote]It the number is always the largest, just use the Max formula.[/quote] Not always the case with my data, otherwise this would be a welcome easy fix!...
Posted on O-T Lounge
Jump to Post - View Topic - Replies (2)
re: Excel help request - GeneralLee
[quote]It might be quicker to just type 206 instead of jumping through all these hoops[/quote] I was just using simple math in my example. This is for a sheet with hundreds of columns of data, when I'm using monthly projections for five years, then switching to annual projections in year 6. But...
Posted on O-T Lounge
Jump to Post - View Topic - Replies (1)
re: Excel help request - GeneralLee
Also, the "blank" cells in my example are not really blank, they are set to equal "". So Index(A:A,CountA(A:A) formula would work if the last cell was really blank, but unfortunately that formula won't work as Excel is reading it as not being completely blank....
Posted on O-T Lounge
Jump to Post - View Topic - Replies (0)
re: Excel help request - GeneralLee
Looks like another formula option could be using Index and CountA functions?...
Posted on O-T Lounge
Jump to Post - View Topic - Replies (1)
re: Excel help request - GeneralLee
VBA is not an option unfortunately....
Posted on O-T Lounge
Jump to Post - View Topic - Replies (3)
Excel help request - GeneralLee
I am looking for an Excel formula to pull up the last number in a series of cells that is not blank. For example, let's say I have five cells, and the numbers may be : 200, 202, 204, 206, and then a blank cell. I want a formula to pull up the 206 value. I am aware of lookup fuctions that can do t...
Posted on O-T Lounge
Jump to Post - View Topic - Replies (13)
re: Many new stories out today of Bloomberg with misogynist comments - GeneralLee
[quote]"We can't have a crass white billionaire from New York running this country." "Let's nominate a crass white billionaire from New York to run this country."[/quote] That is a hope of mine that that's how the electorate would see a Trump vs. Bloomberg election. In that scenario, Trump's ba...
Posted on Political Talk
Jump to Post - View Topic - Replies (0)
re: Star Trek: Picard Season 1 * Spoiler Thread* - GeneralLee
Yep, i'd say Episode 4 is the worst. Show is definitely deteriorating with each episode. Where do we even begin? - Fighting with swords - Three different Romulan secret societies - Picard letting himself be called "JL" and on a galactic apology tour for himself and Starfleet - Thinly veiled po...
Posted on Movie/TV Board
Jump to Post - View Topic - Replies (1)
re: Many new stories out today of Bloomberg with misogynist comments - GeneralLee
[quote]Look at all of the downvotes but the EXACT same thing was said about Trump numerous times on here. [/quote] I would venture to say most conservatives hold this true across politicians of both parties. The difference is liberals claim to have an absolute litmus test on stuff like this, wit...
Posted on Political Talk
Jump to Post - View Topic - Replies (0)
re: Many new stories out today of Bloomberg with misogynist comments - GeneralLee
[quote]Lol as if Trump has never made misogynistic comments[/quote] That is not the point here. ...
Posted on Political Talk
Jump to Post - View Topic - Replies (0)
Many new stories out today of Bloomberg with misogynist comments - GeneralLee
in the 1990's. Not saying we should believe it all, but if liberals are being consistent with #metoo protocol then how can they have him win the Dem nomination? [link=(http://freerepublic.com/focus/f-news/3816818/posts)]LINK[/link]...
Posted on Political Talk
Jump to Post - View Topic - Replies (12)
re: Nyt: Barr installs a prosecutor to review case against Flynn after durham obtains document - GeneralLee
[quote]Attorney General William P. Barr has assigned an outside prosecutor to scrutinize the criminal case against President Trump’s former national security adviser Michael T. Flynn, according to people familiar with the matter. [/quote] I don't see how this gets resolved before November 2020, s...
Posted on Political Talk
Jump to Post - View Topic - Replies (0)
DOJ drops criminal case against McCabe - GeneralLee
[link=(https://www.cnbc.com/2020/02/14/doj-drops-criminal-probe-of-trump-target-andrew-mccabe-a-frequent-trump-target.html)]LINK[/link] WTF! Only potential bright lining of them doing this is because he's getting charged for something outside the April 2018 OIG report. Never mind, I see thi...
Posted on Political Talk
Jump to Post - View Topic - Replies (2)
If Bloomberg is the nominee, I'm afraid he'll drop $10-20B to defeat Trump - GeneralLee
Of course the media will give the Dems a pass when they crowed nonstop for decades about how bad it is for billionaires to buy elections. ...
Posted on Political Talk
Jump to Post - View Topic - Replies (18)