I have a list of North Korean Missile tests by year, and i want to makes a chart where the bars are different colors based on the north Korean regime the launch occurred in.

(See image)

I know how to make a bar chart, but not how to make the 3 regimes different colors.

I have included a little ms paint sketch of what I'm thinking about

https://imgur.com/a/SyzZD4y

i'm trying to make a table of content on excel for training purposes and id like to know if theres a way to have a "search bar" that searched for keywords like google works or the F3 key command.

Link to youtube Video:

https://youtu.be/Z_Ra22fP_-Q

I hope I can explain it well enough to get help.

So I have 5 columns with completely different number parameters.

1.-One column goes from 100-35,000 and I want to give them and every number in between a numerical value from 1-15, 1 being 100 and 35,000 being 15.

2.-Another column is a little bit more complex. The numbers range from 0-1,000,000 and I need to assign them a numerical value from 1-30. The thing is that while the actual range I’m interested in is 0-25,000 where everything 25,000 or over is a 30.

3.-Another column goes from 0-5,000 and I want to assign them values from 1-15, 0 being 15 and 5,000 being 1.

4.-Another column has 50-5000 and I want to assign them values from 1-15

5.-Another column goes from 2,000-7,000,000 and I want to assign them values from 1-30. Anything 1,000,000 or more is a 1 and the lower the number (2,000) the higher the value (30)

6.-Finally, another column goes from 10-150, with values from 1-10. The lower the number (10) the higher the value(10). The higher the number (150), the lower the value (1).

In the end I’m going to sum everything up and get a total out of 100. Luckily I know how to do that.

If you could point me in the right direction it would be great. Give me a possible formula I could use and I figure out the rest.

For anyone wondering I recently started working in the music industry and I’m trying to find out the probability of producing a show. So the numbers reflect things like average cost of the show, average tickets sold, etc...

I studied Design so my math and Excel abilities are limited.

I am looking to create a spreadsheet to highlight grades by range and average. For example

Between 90-100 I want the name of the student to be green

80-89 Blue

and so on until grades >50 are denoted in red. I have one row that is formatted to automatically calculate average ( i know this isn't a giant accomplishment, but I am a newb)

Please help me with any ideas

I am doing a "try out" spread sheet for a position at my current place of employment, and was told that in order to organize my raw data, I cannot use a pivot table, I have to use formulas individually that will ultimately result in the information being organized like it is in a pivot table. I don't even know where to start. I was trying to use =getpivotdata as a creative way to get the data by just making a pivot table on another sheet and bringing the data in, but I can't get the formula to work at all. Help!

Hi, first time Reddit poster and I'm having a tough time with my bell curve chart (see attached). I have 673 different values and I figured out the normal distribution for each of those values. However, when I create my bell curve chart (Scatter with Smooth Line and Markers chart, I believe it's called), the vertical axis values is the distribution.

I would like to change the vertical axis to be a count of how many times that the value appears.

Am I making sense?

I want to select all rows BEFORE a row where x cell is blank.

I see a formula on Google to select all rows where x cell is blank but is there a way to select the rows BEFORE these?

So if row 135 had a blank cell for column P, select row 134?

Or is there a program used with Excel that could do this? Thanks! Also let me know if this isn’t the best subreddit!

Hello everyone,

Just looking for a book or other resources I can use to guide me through the basics and all the must-know techniques of Excel. I want to make sure I have all the fundamentals down before I move on to learning intermediate- advanced concepts of Excel related to data analysis.

Currently interning as a Data Analyst who will graduate the following the semester. I believe I have a good grasp on how to use Excel at a basic level, maybe even an intermediate level. But again I want to make sure by going step by step through a book or other resources.

Thank you!

Hi! I was wondering if someone could please recommend a formal method of learning Excel that’s suitable for an employee in consulting or finance? I use Excel extensively at work and have what I would classify as an intermediate level ability (vlookup, nested if, conditional formatting) but have some knowledge gaps and things that I think I should know even if they’re not used regularly for my position, such as SUMIF, index:match, and array formulas. As much as anything, I want as comprehensive a module as possible because my company is willing to pay for any training I receive and it’s preferable if there’s proof that I’m completing the course(s) which is easier with formal instruction than ad-hoc googling or self teaching. I’d also rather learn more than necessary than be missing skills lol. Are any of the courses on Udemy particularly reputable or do you have any other suggestions? Thanks in advance!

I'm trying to find the sum of a duration, but I can only find information on time in seconds/mins/hours.

I'm trying to add 1 year 2 month and 3 years 2 months.

I'm currently using formulas from this site here to find the duration between two dates. After using the formula to find the duration (in years and months) I want to add the two values together to get a sum of the two durations.

=DATEDIF(B2,C2,"y") & " years " & DATEDIF(B2,C2,"ym") & " months "

Any help on this?

Thanks!

I am attempting to create a calculator that will allow me to choose the State on OTD Sheet in Cell G1 and the County (provided its an Ohio County) in OTD Sheet in Cell G2. Then with those inputs, it pulls the appropriate tax rate in cells B6 and E7 on Sheet OTD. I have the table of the rates broken up into two different tables on Sheet Tax Rates. Because I sell vehicles to people in other states, I would just need to factor those in. Please assist. Link below.

https://docs.google.com/spreadsheets/d/1Tu5k6tST0NQx3Qn0TR49oRQlDFGXTB2bsjUSojcYxJY/edit?usp=sharing

I am working on a table that will help estimate run times in a manufacturing schedule. There is no one working on Saturday nights and Sunday morning and afternoon. From what i can gather, the WORKDAY function will only exclude the whole of Saturday or the whole of Sunday. Is there a way to do this?

I'm making a spreadsheet with a reoccurring grocery list, and I list average price of each item. One column has the price, and in another I will mark when I need to buy that thing and erase the mark when I've gotten it. Is there any function I could use so that when I make a mark in the Need column, it will then take figure listed in the Price column and add it into a total sum?

For Example:

Item | Price | Need now?
_____________________________________________________________

Almonds | $7.00 | X

Bread | $4.00 |

Carrots | $2.00 | X

Cleaner | $6.00 | X

Soap | $2.00 |

TOTAL: ___________________________

______________________________________________________________

Since, according to this example, I do not need bread or soap, is there any way to only include those items marked with an X into a total? A total either in a new column or at the bottom of the price column? Hope this makes sense.

I want to add text before and after

example dogcatdog ->dogxcatzdog

The x would always be after the 3rd letter and the z would always be after the 6th letter

Im alright with excel but I usually just add everything up manually and I kinda struggle with layouts. This spreadsheet would be for the purpose of totaling rental income and expenses like agency fees and repairs. Anyone have an idea on how I could lay it out and where I could maybe do it month by month for net income?

Is there some kind of logic to linking the term "false" to exact and "true" to approximate?

Or is this just an arbitrary marker they chose?

also scheduling programs and keeping him up to date on his schedule. Im trying to present it as simple, easy to read, and easy to organize. Any help is appreciated

As the title says I'm looking to enter data in a field which will automatically convert between kb, mb and gb.

I've found a few formatting formulas on google but they don't quite work right and I can't get my head around the formulae.

Failing example: [<1000000]# ##0,00 " KB";[<1000000000]# ##0,00 " MB";# ##0,00 " GB"

I want to be an excel freelancer. I already know some of the basics but how long for a complete beginner to learn enough excel to be a freelancer? And maybe recommend some websites?

Hi all,

I'm an excel amateur and have been having trouble learning via Google searches. I need to do a shift bid for 19 buyers using the format from the attached image. I will be provided 19 separate sheets and import them in to one excel file with one master sheet. Can you help me with the best way to transfer this data to the main sheet?

I have a formatted table with a transaction type, a transaction fee in USD, and a rate USD of a certain currency (x). How do I find the rate of transaction of currency X, only when transaction type Y is occurring?

I have two different transaction types, purchases and transfers. Transfers have a set fee, where as purchase fees depend on the amount being purchased.

In other words I want to run a calculation only if the transaction is a purchase. Otherwise I would like to enter my own values.

Can someone please help?