How do you calculate the “rate of change” within excel? I am comparing the number of bugs from one week to another.

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

(B-A)/A

like

Then format the column as Percent 💯

like

(B/A)-1 then format as %

like

(New weeks count - Last weeks count) / last weeks count

I do it the same as EY1

like

What everyone else here is saying

like

new/old-1

like

B/A-1

Related Posts

Worried about potential recession and layoffs...

like

Constantly worried I’m going to get fired because I don’t know where I stand at my mid sized law firm (second year associate).

like

Penchooo Weekend hai...fax fux karo...timesheet faad do

Post Photo
likefunny

I bought 5 lobster tails today and a 2 pound bag of shrimp and just went to town dunking everything in melted butter. AMA

likefunny

@Pro-Trump Fishies, will you accept the results of November if Biden wins quietly or will you support fighting it in court?

likehelpful

Pennsylvania, you're killing me.

like

How do you properly vet a law firm? I feel the associates I speak with talk up the firm and aren’t always candid.

like

Anyone else having one of those days where you just can’t seem to do anything right? I’m dropping balls left and right here

like

Does nagarro deducted tax from first month's salary, as company is saying that we can only show our investment once first salary is credited.

like

I joined Nagarro in the first week of September and still haven't received my ADP credentials. In the email it was mentioned I'll receive it on 1st October. 😒 Nagarro

like

What compensation could I expect at Deloitte Digital with 3yrs of Salesforce experience as a consultant in Chicago? Looking for ball park range to help with negotiations

like

Anyone else just absolutely despise Kryterion and their service reps? They are so rude and I just can’t stand it

likefunny

DM me if you have below skills.

Minimum 8 Years experience as Biostatistician. Clinical Domain Knowledge
Statistics
skills i.e., SAP creation & review, randomization, sample size calculation Safety and
Efficacy data analysis, Protocol developments Inputs,
Statistical Review. Project
Management exp, Training and Mentoring

Hi everyone! I'm looking for a freelance or home office job as a paid media analyst or any jobs in the Digital marketing environment.
I have experience working with big clients and manage significant amount of budgets. I've knowledge of Meta business, Twitter ads, Google ADS and analytics, about WordPress and Seo strategies.
I really appreciate any help!
Thank you very much!!

like

Who is more annoying Cross Fitters or vegans?

like

I currently have 2+ years of work experience as a BI Analyst at the GS Bengaluru office. Can anyone help with referrals as I'm looking to move to Singapore to study part time at NTU.

like

How do you add a column to the left side of a ppt table without resizing all the other columns?!

like

Good reasonably priced place in Arlington (preferably near Wilson Blvd) to get a haircut? 23F

like

Help. I’m struggling to find a job that’s $120k and up. I keep getting recruiters reach out on LinkedIn but for half of the salary. Im in the oil and gas, currently working for Philips 66.

Any idea on maybe what positions I should be looking for within this range?

I have 15 years of supply chain experience, transportation and freight forwarding. I also have an MBA. Would like a hybrid, or remote but open to anything.

like

Additional Posts in Excel Genius

Need help with a formula. I’m downloading bank statements to excel and I’m trying to do a lookup so it fills in the category based on the bank description. The problem is I’m trying to use the entire bank description as my lookup value, but the table array I’m searching only has the first part of the descriptions (because the last parts are all different bank ref numbers). How can I do this?

like

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

Today I encountered the strangest bug I have ever seen with Excel+Thinkcell. I have, as always, a separate Thinkcell sheet where I gather and structure the data (from other sheets) I want to make charts of. However, when linking this data to charts, all formulas in the sheet turns into values. This has never happened before. Anyone else seen this and knows what is going on?

like

Hey everyone! I am working on a report with the intention of updating the products that a specific customer uses. Currently, the data is arranged with the unique ID in Column A, and associated products in Column B. However, each product has its own row so company 1234 might have 5 rows and company 5678 might have 20. What I need to do is collect the product data for each unique company and put it into a single row, separated by a comma(s). I am at a crossroads, any suggestions?

like

If you had a table of customer experience/satisfaction survey responses for several questions (non-numeric but discrete possible answers, no free text; 1 question per column and 1 responder per row), how would you approach determining significant insights within the data? Excel's "Analyze Data" feature doesn't really suggest things that make sense in the real world. Is there something you would try with correlations somehow, or would you use a non-Excel tool entirely?

likesmart

Hey guys, I have a Google spreadsheet where each cell has multiple links separated by semi-colons.

How would you get the links to show up in different rows WITHIN a cell? (Pictured is what I want to achieve).

Thank you so much🙏

Post Photo
like

Hey fishies, looking for some help with the below

I have 4 lots of data categories which are assigned a code in the adjacent cell
Eg:
Cell A2= 'xyz' Cell B2 = 'w1'
Cell C2= 'ghi' Cell D2 = 'x1'
Cell E2= 'plm' Cell F2 = 'y1'
Cell G2= 'mhn' Cell H2 = 'z1'

The combination of the 'W','X','Y' and 'Z' codes identity a specific trend
I am extracting data which includes multiple combinations of these codes. What is the best way to show frequency of the codes against the category it is assigned to

like

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

Why don't recent grads know how to use excel?

likehelpfulfunny

Out of curiosity, what percent of your work/analyses are Excel based? And what other softwares do you use the most (Tableau, PowerBI, Alteryx, etc.)

My work has been 90% Excel based 10% Access/SQL based and friends at other firms seem to be using way more advanced programs.

like

Any suggestions for a formula to calculate a running count of the number of incidences in a list? For example, in a list with A, B, C, B; I want to label A = 1, then the first B =1, and first C = 1, and then the second B = 2, etc. The list is in a column and there are thousands of names. TIA for your help!

Hi! I need to give indexes and I compare -322 with 5. The formula I use is iferror(-322/5*100) but the index I get is -6399. This is the only account with that strange difference. Is there something I am not seeing? Because I approach all of them in the same way.

like

Can anybody recommend any excel courses to take for financial analysis? Modeling, valuations, etc. Any direction would be helpful.@

likehelpful

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

like

Any ideas on turning string data into numerical data in excel that’s faster/easier to automate/better than using text to columns? Wish I could use alteryx, but not an option for this use case.

like

What is the best online tool to pick up VBA?

likesmart

I have a large dataset in PowerBI (7m rows) and I’m trying to condense it to pivot in Excel by aggregating the data. Does anyone have experience doing this? How do you pivot and export in Power BI?

like

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

like

Each country has multiple txns. Some complete, some not. What formula should I use to say if Indonesia has ANY “not complete” then show me the term “not done”. Tried IF(Index Match) but only (cont.)

Post Photo
like

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

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