Additional Posts in Excel Genius
Waiting for firms to start posting the processing power of the laptops they issue as a recruitment tool. Would really like PDFs to load.🙄
Any opportunity in SAP ABAP ON HANA , Having 1.5 yrs of experience. Please do kindly respond if you know any openings.
First round at MBB on Friday, any tips?
Pakistani 🐠 - what does "Riyasat - E - Madina" mean ? Saw the phrase in the previous post about IK and Google/quora is giving dumb answers
Please suggest if Motherson sumi infotech of Noida location is a good company to join after 7 years of experience
Hello everyone am looking for Side hustle , anything works driving ,plumbing ,construction etc anything works just hit me up and I I’ll make time to get it done for you thnx 💪
Is citi a good company for me to upskill myself ?
Currently working in a small firm where i take care of a small project all by my own. Will citi map me to a legacy project?
Skill: java , sprinboot etc
Anyone hear anything from Yale today?
What does it mean when someone makes eye contact only with your partner but refuses to make eye contact with you, even when you ask them a question? Always wondered this through the years...
Sometimes I am frustrated with the slowness of our tech development...how does working fast failing fast apply when there are so many iterations...
What's market signing bonus for 4th year associate (corporate) in NY these days for K&E or Latham? What's the max you've heard of this year?
Currently have one offer for 145k plus 12%bonus and should Decide by monday morning. One verbal offer for 150k plus 12%bonus. Verbal provided last wednesday and the offer approval is taking very long. The first is on Azure and second one is more like a manager role with dev teams in India. What should I do?
Trying to sell 2 TVs...
Price negotiable. Facebook Marketplace hasn’t had any hits.
Choosing between industries for Big 4 Audit. Asset Management or Technology Media and Telecommunications to transition into TAS down the line for Major Metro Markets?
Has anyone questioned their choice of partner leading up to the egg retrieval process? Mine has been really unsupportive lately. Got mad and said we should split up last week, keeps calling me crabby from the hormones, etc. It’s to the point I want to see if I can just keep my eggs on ice since I’m going through the process anyways and move on with my life. My best friend told me not to make any huge life changes. Is this amount of mood swings normal?
Additional Posts (overall)
I’m trying to go back to the basics. How do you guys structure thoughts around identifying the correlation between 2 variables? A basic example: the number of steps I take in a day and the hours of sleep I got that night.
Silly question - what’s the difference between the 0 and FALSE in the following VLOOKUP(value,table,column reference,0) and VLOOKUP(value,table,column reference,FALSE)
What task would you expect excel of being able to do but you have never been able to make excel do it.
Just got a dell and getting annoyed learning new shortcuts on excel (had HP prior) - how do I automatically get to cell A1? Used to be CTRL-HOME on HP and Lenovo
I have a master data list on sheet 1. Need to split the data by location (4 locations) on other sheets but only want to update sheet 1 as I get more data. How can I make it so?
How can I index match a relative value?
I want to look up the per unit cost of 280M units, but don’t have an exact match. The numbers in the picture below are actual units/infra I’m searching against
My formula is currently =index(D26:D48,match(B56,B26:B48,1)
I have about 10 variables each with a certain score (10,14,15, 20,20,20,7,9,2,1). I need the max value is there is a single winner (MAX function work here.) If there is a tie for the highest score, I need an output that says “Multiple.” How would I go about this?
Thanks in advance!
Happy Friday Eve
Hi team i have a bit of doubt.
I have an excel sheet where column A is the order numbers. I want to add comments in column G.
There are many repetitions in order numbers but they are all sorted in ascending so all the repetitions are below one another.
If i have a comment, how can i automatically paste that same comment in all the repetitions of that order numbers if i write it in the 1st instance.
Thanks in advance
Also posted in data analytics bowl, but quick question. I am looking to use Tables 1 and Tables 2 in this screenshot to yield the “ideal outcome” table in Power BI (using query editor). The tables I have setup look similar to Table 1 and Table 2 (it’s a mapping activity of controls to various categories). Is anyone familiar with the proper steps / video that will help me arrive at the ideal outcome?
Trying to figure out how to understand the variability of price data along a downward trend. Any ideas? If the data wasn’t trending, I’d just evaluate the distribution of data, maybe normalize it.
When I try to reference a cell in my formula, it won’t let me even click on it and I get the error “There’s a problem with this formula. Not trying to type a formula? When the first character is an equal or minus sign, Excel thinks it’s a formula”
What’s the next step in better pay as an HR Coordinator? I’m currently picking up a data analytics certificate for fresher skillsets. I’m aiming for $80-$90k salary at the moment.
For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?
Hello Excel Geniuses- I need help. I have never learned macros but I’m about to but before I invest the few hours or however long it might take, I wanted to find out if it is possible to do what...
Looking to do data analytics for nonprofit organizations. Any forms or websites to look?
Any ideas on how to sumif based on criteria listed under a given header wherein the header is the main reference but there are varying criteria beneath said header? Specifically, I would like to drag a formula down a column that references a corresponding department in the row (the header on a sep sheet) and then sums the listed accounts beneath each dept (with each dept having a diff # of accounts) from a given data set. Could do a pivot, but the filtering process is inefficient.
Hey everyone, I'm looking to get some help tracking product sales for my business. I have an excel sheet, but it still needs some work. Can anyone help?
I have zip-zip routes for a trucking company. Most of them have price info but some are blank. Is it possible to do a count of those with price and without price in two columns of a pivot? I want to show that prices are missing across the board and that we can use the majority to replicate the missing few.
New to Fishbowl?
unlock all discussions on Fishbowl.