Hi, I’m trying to bring in data that is in the middle of my data set but the issue is my data might change from day to day and entity to entity. Let’s say tomorrow or for another entity the data might be between row 199 and row 500.

I want to use the Filter formula to look up values starting in one account number and ending in another account number in the same column but in dynamic rows. Is this possible?

Thank you in advance to all you excel geniuses out there.

Okay finance lawyers. I don't understand this issue. Client says books show we're highly profitable but we have no way to pay our tax liability.... Well where the hell did tbe money go ? Client also claims that they are only taking a small portion of the revenue as profit. I don't understand how your books can be different than reality.

Opinions on career clerkships? Especially with a two year old and wanting another child eventually.

Dear all
What is the maximum salary for mechanical designer II (band 3) Honeywell India?
Years of experience for me 5+

I appreciate your time and support!

Is giving birth w/o the epidural really that crazy of a concept? People laugh at me when I say its very feasible...

Do you guys charge vacation form holidays or excused leave?

I'm trying to make the most of my time off from the hospital, but I just can't seem to recharge for life stuff and errands, how do you balance work and life?

Hi Fishes

How much hike relaince jio gives every year?

My Dad has over 28 years of experience in Managing accounts and Finance of various companies. He’s really struggled a lot to get where he is right now. His current company is facing financial difficulties- anyone who can refer him for any Finance and Accounting senior opportunities in Dubai - please help. Literally crying for help.

Are there any crunchy hiker folks out here? Would love to talk with y’all!

Hey everyone, I'm looking at a new knife as an Xmas gift to myself, looking to spend $200+ on a really great quality knife. My last one was a Global 10" chef's knife (G16) I gifted away, but now looking at a Global Sai 9 3/4" (Sai06), anyone got thoughts / opinions?

Had my 1:1 with my People Lead yesterday to prepare for talent discussions. Said I had a great year - but need to work on being consistent. She said when I’m engaged it’s great but need to keep it going. I’ve mentioned my ADHD previously but I’m sure she doesn’t know all the components of what that means. We’ve had org issues - no clear role descriptions or expectations. Yes I do have a hard time staying engaged (and I’m medicated - Vyvance in the am, dextroamphetamine at noon). Thoughts?

What are some of the investing must-reads that you'd recommend?

Will Amex restricting guess access for Centurion Lounge actually make any difference?

I can see short term changes but the way Amex has been aggressively marketing Platinum card, we just will have overcrowding of primary card holders 🤷🏻‍♂️

What's next, everyone has to spend min. 50k a year to get Centurion lounge access or pay per visit.

Hi People, Need some advice. Currently I am in EY India, joined it 7 months back.
Got an offer from Nagarro with 18LPA(17 fixed).
Should i consider switching? Please suggest. YoE-3.6 years. Current CTC- 10.7 Lpa. Tech stack- Java Spring Boot.

I have observed that people on testing domain or frontend are getting better pay than other new tech domains like blockchain, cyber security, data sci etc(4-11yr exp) .
For less than 4 years experience new tech job gettig good pay but others getting very less.

In dev job Java, spring r etc getting better pay. Also some SAP consultant are also get paid high.
Is exp people in testing/frontend dev are less due to which they getting better pay than others with experience.
Based on fish posts*

When I am looking at an email attachment in Outlook it shows the Google Chrome logo but when I open, it opens in Adobe which is what I want. Even though it is opening an Adobe, my boss would like it to show the Adobe icon instead of chrome next to the attachment… anyone know how to do this ?

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”

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

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.

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

I’m trying to learn more about Excel functionality and there’s several simple functions that I don’t know, this is probably one. If I am color coding data, is there a way to automatically move those lines to the top or bottom of the spreadsheet once the color code for the line is made?

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

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

Any book recommendations on excel modeling for real world business applications?

Hi All,
Looking to automate a manual process for the client and thinking of creating macros for with VBA. Has anyone done anything similar?

In the process of learning but wanted to reach out for any tips, tricks and advice anyone may have.

Thanks I’m advance.

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 ...

Timesaver: If you’re working on a file saved on the cloud (teams, share point, etc.) and need the URL to communicate out, tap FILE -> INFO -> COPY PATH and the url will be on your clipboard. Pre-established sharing privileges of orig folder will apply. Hopefully this saves you time reshuffling open windows! Bonus: Same on standard MS suite files.

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

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)

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

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.