Hello,

I was wondering about improving my spreadsheet to keep track of results. So as of right now I just calculate time start, time end. The equation I use is =IF(C2<B2,C2+1,C2)-B2. B2= time start C2= time stopped, D2=total time played. And also BR start BR end for profit. I would like to calculate total hours per day/week/month.

Also is it possible to speed up or automate any of the entries, like for example I'm always entering the BR ended into new BR started. Any tips and help highly appreciated.

That'd be pretty easy, but depends on exactly what you want and how it should look. If the bankroll isn't changing between sessions, just reference the last entry in the new cell. You can build a line chart in another worksheet as well to show your results as well.

Yea one of my friends basically told me for BR to just set the new = to the last cell.

https://gyazo.com/be93b29864a128d8683b469d94f6a37d

This is how I have it set up at the moment. What I would like to do is to be able to set it up where I can see the total hours and profit for the day/week/month. Similar to how you would be able to see it in HM2. I have been having trouble getting hhs from ignition so I keep track of profits manually. Ignition starting/ending is just basically BR.

As of right now, I just basically have a separate entry for each session. So right now what I'm having trouble with is figuring out exactly how to show the data I want to see and exact formulas to use. I think I have to use IF function but to be honest I can't seem to figure it out so I'm hoping someone more experienced and knowledgeable with excel can give me some advice.

I wouldn't mind paying someone to set up a nice spreadsheet for me (long as it's within reason). I think for someone knowledgeable and who knows what they are doing, it shouldn't take very long. It's just been way too long since i took an excel course and I don't remember anything haha.

PM me if interested please .

I'm having a hard time laying out a spreadsheet in a way I can see and compare some items.

These are the items I need to include in my spreadsheet:
Video Title
Date uploaded
Current Date
Days since uploaded
Total views
Total downloads
Today's views
Today's downloads

I just need help laying this information out so I can easily add the new numbers each day. I also need to see how these videos are performing each day as they get older and older from the original upload date.

I have several videos I need to track so the other challenge is that I'd like to have the data for each video next to each other (or right above/below each other) so I can see how one video is doing compared to others.

Anyone have any idea how to lay this information out?

I have a spreadsheet with a formula finding the days between some dates. How can I show a blank in the cell with the formula if one fo the dates has not been entered yet?

I have a date in cell B6 and another date in U6. I have a formula in cell V5 of: =U6-B6

I have this formula copied down the entire column of V. Some dates have not been entered in columnn U yet so the results that show in column V are all wacked until I enter a date in column U.

How can I change the formula in column V so it will remain blank if nothing is entered into column U?

For example, if I have a date entered in B23, but no date entered into U23, I'd like V23 to remain blank.


Thanks in advance!

if(U23="","",U23-B23)

I'm creating a pivot report using OLAP (the fact that it is OLAP probably shouldn't matter).

In the Filters section, I have Part Number
In the Rows section, I have Industry
In the Values section, I have Revenue

The Part Number filter is currently set to only show PartNumberA.

I want to have the report show the Revenue for PartNumberA vs all part numbers side by side without having to pull the Part Number filter down into a column or row since it explodes the chart. I just want to show 3 columns like below:

Industry : Revenue for Part A: Revenue for all Parts

IndustryA 50000 99383333
IndustryB 60000 45346666
IndustryC 70000 45466645

Can you help?

In Alalyze-->OLAP Tools you can create your own measure using MDX. So you could create a measure for Revenue where Part Number = A and a separate measure for Revenue where Part Number =/= A. I don't know the MDX code off the top of my head though.

In a standard pivot you could group all the other parts, but I don't think an OLAP connection will let you. I think the only way to group if it's an OLAP connection is to create a hierarchy in the backend.

Thank you for responding, i know i am late in my acknowledgement. Ill take a look at the suggestions you made, im not sure if there is a new system of coding as these are pre coded by the manufacturers...Its kind of a proprietary system to the industry. Changing coding would just cause mass confusion when comparing to other sort lists.

I'm running into an issue and I can't figure out the problem. Each day I have to create a couple of rows of data based off certain information. Data includes words, numbers, and dates. Once I'm done with all the information, I have to save it in CSV (comma delimited format). All the cells are in the General format except for the dates which are in Short Date format.

Once the file is saved in CSV (comma delimited), I'll close it and re-open. Some of the numbers change. Example: In the sheet, I'll have three different rows in a column with the following numbers:

1056409843251
7853143251
9654343251

Once I save in CSV (comma delimited), close and re-open, the column now reads:

1056410000000
7853143251
9654343251

Not only has the top number changed, but it is also changed from General format to Scientific. Can someone tell me why it changed and how I can avoid this in the future? Thanks.

Its a common error where excel changes notation automatically to Scientific.

http://support.pitneybowes.com/Searc...lse&lang=en_US

See that link to see how to stop it (basically have to format as text to prevent it.)

Hello,

We have many clients that are us residents and require fifo gain/loss reporting when the firms resources are insufficient. How would you use excel to prep these reports given buy and sell transaction data assorted by settlement date? Can this be done via vba?

I want to add the word "Months" in the same cell as I have a calculation in. I tried to use:
=(H13/G19)&" Months"

This works, but the calculation I get has way too many decimal points. I tried to format so it only has two, but it still shows about 15.

The result I get now is:
3.213676384 Months

Is there a way to format to only two decimal points if I also want to have a word in the cell?

I'd like to show the result simply as:
3.21 Months

Thanks!

If the numerical value is in cell A1:

=CONCAT(ROUND(A1,2)," months")

You could also use the TEXT(value, format) formula.

Sorry guys, I'm not that great with excel.

Right now, this is the exact formula I am using:
=(H13/G19)&" Months"

What should the exact formula be to use?

=ROUND(H13/G19,0)&" months" if you want integer months

=ROUND(H13/G19,2)&" months" if you want decimal (ie 6.45) months

Perfect! Thank you aditya!!!

Thank you in advance for any help. I am wanting to download 6 different reports from https://baseballsavant.mlb.com/statcast_search and have them show up in 6 seperate sheets on a daily basis. The only thing that will change daily is the date range. Is there anyway to automate this using excel?

I have a spreadsheet that doesn't look nice enough to show a potential customer. I need to clean it up and make it look more presentable.

Here's the data I have (with details removed




Any ideas to make it look more professional? How would you reformat the data? Would you add some type of chart to show the potential savings based on the three shipments areas they can save on? Any suggestions would be appreciated.


Thanks!!!

I think this looks nice enough. Not a major fan of the color scheme but I am not an expert on this. Maybe show some consistency on the decimals for the percentages.

Surely, from the looks of it, this should be something the customer is excited about without having a nice chart or anything.

Dumb Excel help needed. Doing a budget. Say the 12 months listed in the file is 100 per month

100 100 100 100 100 100 100 100 100 100 100 100 (Sum : 1200)

I realize by my research total tax should be 1500 for the year.

How can I write a formula to calculate the change in amount so I can do this for 2000+ cases. Keep in mind that the first 6 months of the year are locked (cannot change 1st six 100s).

Is there a way to use conditional formatting (or something else) to highlight multiple cells if, and only if they all match. I can easily use conditional formatting to highlight a series of individual cells if they match, but not sure how to use that same idea to highlight a series of multiple cells if they match.

Example

Cell K5 =Tony
Cell L5 = Henderson
Cell M5 = Phoenix
(HIGHLIGHT)

Cell K6 =Tony
Cell L6 = Henderson
Cell M6 = San Diego
DO NOT HIGHLIGHT

Cell K7 =Tony
Cell L7 = Williams
Cell M7 = San Diego
DO NOT HIGHLIGHT

Cell K8 =Tony
Cell L8 = Henderson
Cell M8 = Phoenix
(HIGHLIGHT)

Cell K9 =Tony
Cell L9 = Williams
Cell M9 = Phoenix
DO NOT HIGHLIGHT


I'd like to only highlight the series of cells when all three match exactly. Would there be an easy way to go about doing this?


Thanks all!!!

I'm trying to count a group of cells (not in a continuous range) that contain a value greater than 0.

I'm trying to use the COUNTIF function.

The problem I'm having is that the group of cells are all in random places on my spreadsheet. I've tried to separate each cell with a comma, but that didn't work.

How can I include a random group of cells in a COUNTIF function? Or would there be a better function to use for this purpose?

I'd like to count all cells that are greater than 0 from this group of cells:

C5
C11
H29
M41
etc......


What formula would you use to count all these cells that are greater than 0?

Thanks!!!

=SUM(COUNTIF(INDIRECT({"K21","K25","M24","O22","P2 8","Q24","S24"}),">"&0))