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, ...

[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. ...

[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...

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...

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....

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....

[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!...

[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...

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....

Looks like another formula option could be using Index and CountA functions?...

VBA is not an option unfortunately....

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...

[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...

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...

[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...

[quote]Lol as if Trump has never made misogynistic comments[/quote] That is not the point here. ...

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]...

[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...

[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...

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. ...