Using Google sheet and not sure why the MAX ROW formula is giving me 10 instead of 12? Help!!!

Post Photo
Posting as :
works at
You are currently posting as works at

What’s in row 10?

Ok it worked 😼

Post Photo
like

Related Posts

Can anyone help me or suggest me with accomodation in whitesfield near to cg office?
under 10k.

like

For those who like litigation, but not personal injury and premises liability claims, why areas are you feeling the most traction in while looking for lateral moves to other firms?

I passed out in 2013 and started job in 2015 on contractual basis till mid 2017 and during this Many payroll companies changed for that particular contract and in this duration my PF, tax didn't deduct and no record in PF portal. Then joined Infosys in mid 2017. So now wanted to know can I show my experience from 2017 to apply in companies as for bgv many companies ask for PF statement or form 16 for all previous companies. How should I deal for 4 years gap if i show exp. from 2017 ?

like

Graduated May 2019, can I apply for campus hire jobs 🙂

like

Anyone from Seattle?

Any book recommendations on advanced procurement/sourcing concepts?

Most popular books I find such as 'Procurement and Supply Manager's Desk Reference' are not detailed/deep enough.

like

To those using Prosystemsfx, have you had issues with not being able to insert rows or indent text in Excel? I’m sure there’s more but those two not working really bugs me

like

Hi Fishes,
Have some queries regarding Eli Lilly, can someone come on DMs for it?

like
like

Hiring for an early stage Venture Capital for Bangalore location.
Candidates meeting below criteria may connect with me at
nikitayadav@michaelpage.co.in

1. Candidates with excellent education pedigree (MBA Graduates from 2018/2019/2020 batches only)
2. Non-engineering background preferred
3. 1-2 years of post MBA experience in investment banking (tech focused) or start ups (product/ strategy/ CEO's office roles)

like

Rewatching Breakfast at Tiffany’s. What’s good?

like

Hi,

Any idea what the next step is? I've applied to multiple jobs and can't seem to get an email as they say in this screenshot.

Or could anybody refer me to job id : 292647, that would be really helpful and appreciated.

Thanks

Post Photo
like

Anyone have consulting experience in Austria? I’m moving to Vienna and trying to get a sense of salary for an experienced SM in management consulting. Any insight? Thanks!

like

I’m joining in Aug end, can someone help me with sharing details regarding appraisal and bonus cycle. Moreover how much appraisal I can expect. For KPMG india

Can someone explain what is the diff bw Assurance and Consulting?

like

What do you do to be aware what peers and others outside your circle are up to?

Are there actually tax cuts switching from home office in NYC to Hoboken?

like

⚠️Toxicity Alert ⚠️

My previous manager would track us by hours daily, made a fuss everytime anything stretched and guilt us for that and the unplanned leave too unless it was COVID. Hinted him a lot of time, this is problematic but apparently he considered it "standard practice for agile".

Now 8/10 teammates have switched within < 1 year of project start (6-7 months with him) which tbh had good work in our opinion and even team was fun to work with even though none of us ever met in person.

Additional Posts in Excel Genius

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

like

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

likefunny

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

like

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

How do I compare two sheets to make sure they are identical?

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!

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.

like

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

like

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

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

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

like

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

Excel Rookie looking for a super simple formula to bring all information linked to a certain date in tab 1 to be organized under said date in tab 2.

like

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

like

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

Does anyone from PwC have a list of the favorite groups shortcuts for excel? Please provide. Much appreciated .

like

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

like

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?

like

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

helpful

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