million

My cell a96 contains "$82 Million Cash Value $51.4 Million" I need b96 to show 82000000 which I can do using =VALUE(TRIM(LEFT(A69,LEN(A69)-33)))*1000000 I also need c96 to show 51400000 But feel that may present problem if if cash value is less than 33 characters The numbers can change -...

Hi guys, I hope you can help me, as I've tried many different options and am out of options (excel will not accept my formula). I am trying to construct data validation *custom*, where user can only insert phone number OR email address; this is what I have figured out so far...

I have never used access, but just started to investigate the limitations for a potential project. My data sets will have approximately 13 million fields quarterly, and I will eventually need 60 quarters worth of data. That's around 260 million data points. Nearest I can figure, it's about...

Hello, Trying to use powerpivot have a table with 14 million rows, then I want to filter this table by using another table with selections that appear in one of the columns in the main data table (14 million row). Anyone know how to do this? Any links to guides be appreciated. Many thanks.

What would be the best method of loading a .txt file with 14 million records into 1 spreadsheet? Is this possible? If not, what are my best alternative methods that you all would suggest? Thanks for your help! :)

Hello, Basically I have an issue that is probably best served with a database. I have an excel sheet that is 1.5 million rows (spread across 20 tabs). I don't have access to a database program. I need to do something that would be simple with a pivot table, but I can't pivot 1.5 million...