I have to revert a scale of 1-13 to 1-5, any advice on how to do / automate this? TIA 🙌🏽

like
Posting as :
works at
You are currently posting as works at

=([cell reference]/13)*5

like

Extra column, =(old value/13)*5
Bonus points for making 13 & 5 flexible by using a cell reference rather than hard coded numbers.

like

Ahhh I see! Thank you. So if I had something where the bottom of the range was 0 like 0-3, and I wanted to convert it to 1-5, would I still need to subtract the one or no?

Use this formula, where x is the value you want to scale, a is the minimum value you want (1), and b is the maximum value you want (5).

This method is known as min-max scaling and is commonly used by data scientists around the world.

Post Photo
like

Lookup formula?

Not sure if i quite understand fully but if the old scale translates to the new scale consistently (i.e. 1-3 in original scale would always translate to 1 of new scale, 4-6 would translate to 2, etc.) then a simple lookup would suffice. Create a mapping table and apply to data using your preferred lookup method.

Where are you having trouble with excel in reducing the scale?

Subtract 8

Lol

For all the answers prior to this point….If you also need it to only be 1, 2,3,4 or 5 then throw a round function on your formula.

Related Posts

Does anyone have motivating/good sales books to recommend?

like

Would you ever work in a hotel? I've heard some weird stories but being a tourism graduate, I know that this will bring me some great opportunities in the future.

like

What makes you want to learn yet another programming framework / library / language besides the stack at work?

like

Finally got my first G Shock (royal oak)!

Post Photo
likeuplifting

So sorry if this has been asked but, are we allowed to use zoom/teams meetings/Skype for calls with friends outside the company?

like

Hello fishes &sharks ,
Im woking as Assistant Manager in byjus. For
past 3yrs im working here only. Salary LPA -7.6

Please suggest me good companies to try and guide me getting better package and which bracket I should target.

Hi! Does anyone here work at FloQast in sales? Would love to hear about your experience and the comp (specifically for the BDR role) thanks!

like

“The client has authorized 3 hours of billable research and 1 billable hour for writing the memo, that should be MORE than sufficient to research the position of each circuit on this asinine issue that I thought of at 3AM this morning because I couldn’t sleep so I thought of ways to ruin your life instead!!!! Xoxo managing partner.”

Post Photo
likefunny

Hi all,

I am joining Natwest Group in July 2022 and as per my agreement with HR and manager, I will be working from office after 2 months of joining (from September onwards)

My question is how will my onboarding be online or I have to be in office for onboarding process.

Your help is highly appreciated

Got a LinkedIn profile view from Wharton, anyone know what this means, if anything?

like

Does anyone else get such awful periods that you basically can’t work / get violently ill? Mine have been getting worse and worse and I’ve tried BC and hasn’t really done much for me. :(

like

Saathiyo 😌
Deloitte EY KPMG PwC

Post Photo
funnylike

I’ve seen this spark a little debate on LinkedIn. But now let’s bring it to the most brutal arena of all “The Fishbowl” 😆(evil laugh)

What do you think of this Ad?

Post Photo
like

Any before I start this ppt deck slideshow, I’d like to give a shout out to our sponsor today Grammarly, Grammarly is a….

Imagine if we started taking paid ads like YouTubers during our client presentations

funnylikeuplifting

RANT: People re-writing a cw’s stuff has always been painful. These days it’s far more common than when I started. It’d be one thing if they upgraded the work. If I learned from it. If I genuinely seethed with envy over their wit w/that perfectly placed semi-colon. People can’t re-art direct stuff bc they don’t know the programs so they ask the ADs for changes. Word and a keyboard made everyone think they can write. Which they can’t. Google Slides is Google slip ‘n slide into (bad ref. here.)

like

What is the difference between Standard Chartered Bank Grade 07-Band 7(specialist, product engineer) vs Barclays BA4?

like
like
like

Hi,

My joining in JPMC is on 12th Sept. My BU is CIB and department is given as NAMR asset servicing India. Could anyone please let me know about the wlb/ work culture in this department.

Thanks in advance:)

What is the average salary for business analysts with non-IT background having 2+ yoe in large banks?

like

Additional Posts in Excel Genius

Workaround for a median ifs formula? I’m assuming an array but cant nail it

Is there any big advantage of using gsheets over excel?

like

Anyone run into an instance where one VBA goal seek will work within a loop and then another vba goal seek not in a loop within the same workbook won’t work? I’ve done some google research and it seems like it might be a COM add-in problem but wondering if others have exp this.

like

Having trouble with data dependent drop down list. In sheet 1 I have “type” and “subtype” columns that are blank and I need column B to be a data dependent drop down of A. The master data is the format:
(A.) (B)
T1 S1
T1. S2
T1. S3
T2 S4
T2 S5

How can I have my list show only S1-3 if I type in T1 in column A? (T1 = type 1, S1 = subtype 1) there are multiple words, spaces, and numbers for the data as well

like

SUMIFS wildcard question: is there a way to pick up values based on the cell containing a wild card? (So not an in formula wildcard)
Example: I have scenario A1, A2, & B1
Some criteria apply to both A1 & A2, and I would like to not duplicate the criteria. So when the user selects scenario A1, I want to pick up criteria A* & A1, but not A2. For selecting scenario A2, I want to pick up criteria A* & A2, but not A1.

like

Can someone explain how to build a Monte Carlo simulation in excel ? Videos in YouTube aren’t helping.

like

HELP: ok, here’s the deal. I have a list of dates stored as text that are all in VERY different formats. Some are so wonky that, even when converting everything to an excel date value, excel won’t recognize the input as a date. So far I’ve been nesting a massive =if() statement with functions such as =search(text), =len(), =right(), =left(), =xlookup (for month abbreviations), etc. I’m wondering if anyone knows or has a formula that can convert even the wonkiest dates into a coherent format.

Post Photo
like

How do I convert a google doc link to excel?

likesmart

Any ideas for how to reshape a dataset from wide (panel) format with two column header rows to long (pivot) format while keeping one column header row?

Post Photo
like

Whenever I press Enable Content, Excel crashes (and does an infinite loop). I can’t seem to break link the cell that is supposedly linked to an external source. Anyone know how to solve this?

like

Google Sheets vs Excel - pros and cons? Asking seriously.

like

Noob question using Excel 2016 (new job not yet on 365). I just inherited a large workbook that has multiple data tables, or so it seems as I see that they are calculating. However I cannot find them using find and select, they're not in hidden tabs, there's no range with such name etc. They're all scenario analysis. So how / where do I find them? I'd like to understand and update the underlying calculations. See pic if that helps. Thanks a lot!

Post Photo
like

I would like to create a geographic heat map in excel using a list of addresses that will be continuously added to and would like the map to update as addresses are added. TIA

like

Really basic q but I forgot how to do it - how do I grab all the text after “@“ for a column of email addresses?

like

I’ve Paid 3 ppl who couldn’t do this for me on Fiver. I run a football Tournament. The last number is the Total points. How do I set this up where it moves it moves up or down automatically

like

It's that time...🦃

What function are you most grateful for in Excel? 😎

Drop it below! 👇

likehelpful

Need some urgent help with using if and vlookup together. Anyone willing to help via direct messages please?

like

Does anyone know a shortcut for unhiding rows/columns. I.e. the inverse of Ctrl+9 and Ctrl+0?

like

Are courses (either Marquee or other in-person offerings, or online) notably worth it or did you find learning on the job to be sufficient/better? Considering enrolling but wanted to gauge first.

like

Hello All,
Excel help please. I’m trying to combine 3 tabs into 1. So on tabs a,b,c I have wire instructions that go to different places, but they all have the same field names/format. However the number of rows for each tab will vary from day to day. I need to make a fourth tab that shows all the rows from a,b,c consecutively. Because the number of rows change, I can’t find the best way to collate all the rows into one table. I can use a macro or lookups or a source formula. Please advise!
Mo

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal