sincerely appreciate it, I'll see if I can get it working

I'm sure this question will betray me as a giant noob, but that's fine.

I've drawn up a basic spreadsheet for daily accounting of a player's account activity. It's intentionally simplistic, and merely requires the player to enter his closing balance, number of games played and any transfers in/out. The spreadsheet will carry over the account balance to the next day, calculate daily profit/loss, and keep running totals of profit and the number of games played.

I'm just getting frustrated by the fact that I don't know how to hide values that need not be calculated yet. Here's a screenshot that illustrates what I mean:



I want G5, H5 and I5 to be blank. I only want them to show values when there is an entry in E5. I know how to hide 0 values, but I don't know how to hide "unwanted" values. Can someone help please?!

Post this in the cells you want to be blank if no values exist.

great, thanks!

Is there a way to open files in different excel windows automatically on startup?

The way I do it at the moment is that I run five different excel windows and then open the files in each, if I try just putting the files in the startup folder they open in the same excel window.

I think you can do this via command line code / .bat file.

On sheet1 I have a list of values which are conditionally formatted using one of the default colour scales. I want to be able to refer to those cells on other sheets and modify the content slightly (Say divide it by 2), but have the same conditional formatting apply from sheet1.

So if I have A1:A10 on sheet1, and A3 is a certain colour, I want to be able to have a cell on sheet2 with the contents =A3/2 show up as the same colour. I guess I want to know if I reference a cell's conditional format separately from from it's contents.

Any pointers? I'm on Excel 2013.

Does anyone know how i can do this please...
when i dump my raw sales data in each sale is shown in a list view with date dd/mm/yyyy. I want to create a graph which is dynamic but is categorised buy months so i see total sales for Jan-13 etc. using the offset i can get the graph to be dynamic but it doesn't get categorised by months, only shows lists of days. when a new month has data and is entered is there a way this can by dynamically summarised which i an then run the graph from? sorry if im not explaining this very well. cheers.

This page


http://www.fangraphs.com/leaders.asp...ter=&players=0


has an 'Export Data' link which generates a csv. The export link calls


javascript:__doPostBack('LeaderBoard1$cmdCSV','')



Can I import this to Excel? Do I use ie. document.parentWindow.execScript? I could use help with the syntax.

I'm always so embarrassed by my questions when I see the complexity of everyone else's. when I try to specify a destination for a pivot table I get an error each time. Is there more to it than selecting "specify destination" and clicking the tab I want it in?

Thanks

Probably way too late but this is a good aid to the basics of pivot tables
http://www.youtube.com/watch?v=bvoBb-bT8IA

I need a formula that will allow me to generate a random number, with a weighted probability of different ranges. For example, the random number should fall between:

0-250 20% of the time
251 - 500 30% of the time
501 - 1000 50% of the time

I would like to be able to adjust the ranges and frequencies, so that I can view different curves of outcomes, based on the ranges and probability weighting towards those ranges.

Thanks for this thread. I reference it all the time.

First make a table with your lower and upper bounds and frequency as fields. Then use RAND to pick which interval. For example if RAND returns 0-.2, choose the first interval, 0.2-0.5 the second interval...
Then use RANDBETWEEN with the applicable lower and upper bounds.

The tricky part is using the RAND result to lookup the bounds in your table. You can do it using INDEX / MATCH with match type = - 1. You'll need a column that calcs a running total of the frequencies.

Image: http://db.tt/r37pkD71

Now you can match the RAND result to column D.

Edit: Columns C and D should be divided by 100, or multiply RAND by 100

Ok that doesn't quite work because a match type of -1 requires the list be sorted in descending order. So I did a match type = 1 (which finds the next smallest result) but then added 1 to the result to get the row below.



Formulas:

I also heard this the very first time about Lotus.

A solution in a single formula, although annoying to change and definitely not for sophisticated weights, would be:

=CHOOSE(RANDBETWEEN(1,10),RANDBETWEEN(0,250),RANDB ETWEEN(0,250),RANDBETWEEN(251,500),RANDBETWEEN(251 ,500),RANDBETWEEN(251,500),RANDBETWEEN(501,1000),R ANDBETWEEN(501,1000),RANDBETWEEN(501,1000),RANDBET WEEN(501,1000),RANDBETWEEN(501,1000))

I am trying to make a formula that makes a running total of how many of each size a doctor bought(circled in red) in the column(circled in blue). If it matters the column with the red circle is a drop down menu of all of the doctors in the blue circled column.

I tried =COUNTIF($C$10:$C$7000,I7=B10) obviously this didnt work.

anyone have a formula suggestion?

In column J:
=SUMIF($B$10:$B$7000,$I7,C$10:C$7000)
Copy to columns K, L, etc.

Don't know if this is possible with excel.

I would like to have a function where data could be entered into one box multiple times without the need of storage of the number. ATM my spreadsheet is based on months and venues(home games, online, casino) to record profit/loss. After each session I have to add or subtract from the current total for each venue for each month. This is fine if I visit one venue per month but say I visit the casino 6 times in a month when I get home I take my profit/loss and compile it with the current total. I was wondering if it would be possible to have a box that would say enter profit/loss here and automatically add to the column without needing to store the data.

Blah45 - this, but be careful with entering the $s. $i7, not $i$7 etc.

across two worksheets. I need to provide a formula to factor billing based on customer type. The formula is "'gal billed' X 'billing rate on second worksheet' / '1000'"

=IF([@[Cust Type]]="nprofit",[@[Gal Billed]]*'Billing Rate'!G6/1000),IF([@[Cust Type]]="com",[@[Gal Billed]]*'Billing Rate'!F6/1000,[@[Gal Billed]]*'Billing Rate'!H6/1000)

I am getting a value error


nm, I needed to use absolute references on the second workbook

THANK YOU!!!!! Very complicated I would have never figured it out still playing around with it. When i drag it down to copy for every cell it is having issues. I will manually type all of them to ensure functionality

thank you for this tip. much appreciated.

This worked out great. Thank you!

Bit of a long shot, but does anyone know how to create a multi-page pdf file from a single Excel sheet? I want to run a macro to change certain cells and then create a pdf for each iteration. It would really help if it could be to single pdf but it may not be viable.

How many iterations?