How do you use countif formula on an entire column that doesn’t count the header? My column header is a date and the rest of the rows within the column are either 0 or 1. What I have now is =countif( A:A,”<>0”)

Anyone have a suggestion for a nice bracelet or ring for a college graduate gift (up to $500)? Thank you in advance! :)

Any openings for Data Engineering profile?
Skills - Snowflake, AWS, Matillion, Airflow
YOE - 4.6

Can we extend the joining date in sap labs because relieving date and joining date is overlapping on 22nd August 2022

Hi Fishes,
Salesforce making any change to the work location flexibility once offices are re-opened? Support roles are Hyd based why other locations cannot be utilised?

Hi all!
Want to break into IB in London (BB's and EB's) as an Associate.
Anyone willing to refer or can share any info?

Thanks!

Hey Fishes 🐟,

Where can I get study material for SAP IS-U ? I visited lot of sites but couldn't find detailed explanation for each concept.

Any companies hiring for Forensic Accounting (Investigations, Litigations, AML, etc.) I have both my CPA and CFE.

Hi all,
I am currently working in infosys as Devops consultant with 4.4 exp and looking to switch company. Can anyone refer me in tcs ?

Can you be a brand strategist and hate competitive reviews? Today’s philosophical pondering

3bhk available in Kalyani Nagar near FML from January . Rent~ 45k
3 washrooms
Beds and Wardrobe in all room
Chair tables
Fridge
Gas Line and equipped kitchen
Personal Terrace for your flat

DM me if interested. Can directly connect you with owner.

We are vacating the flat as 2 roommates are leaving for personal reasons

I'm updating my resume for the first time in 3 years and I'm struggling with how long it should be. I can get everything on to one page, but if I want to elaborate about my experience, it's going to be 1.5-2 pages.

What does the branch transfer process look like for UBS? I'm wanting to transfer from my current office to one closer to home.

Have any 🐠 here joined a PE fund as an LP?

How do PE firms update the EV on an acquisition? So if they acquire a company in February at $X EV and want to value the company in December, would you just add the EBITDA generated for the rest of the year (March-December) to the original EV?

What are some exits for someone with IT strategy from consulting?

Do you take yr parents to award ceremonies

Been in Sales for 12years, done it all from transactional to complex, from 10k to 650M and from local to global, and 2 weeks to 24 months Sales Cycles - now aiming to move into a management role within the next two years, ideally mid sized business, build and execute a strategy for growth, shape a vision and drive the overall success on a more strategic level. Led teams and managers.

Masters and getting my MBA done currently - any advise what is key to make it happen?

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

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?

What would you consider "Advanced" or "Expert" level Excel usage?

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?

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

Would anyone be willing to teach me vlookup?

Can you share the most useful formulae and built in automation features you have used with the latest version of excel?

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?

Hi! I’m trying to create a macro that pulls a copy of a sheet from a file with a certain date in the file name into a new workbook. Is there a way to do this?

Top 3 most useful VBA macro codes you use everyday? Would you mind sharing the VBA code or a link showing the code? I’ll start (cont.)

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?

Anyone know why a SUMPRODUCT cell would return to zero?

The error said ‘inconsistent formula’... (cont’d)

Looking to get rid of ALT+ENTER in cells, it’s messing up my import file formatting when I convert the file to .txt.

Could some recommend a way to do this quickly, I’ve tried find and replace control j, and that worked on most but not all cells.

Most used or favorite Shortcut? Ctrl + Z doesn’t count

Has anybody used the COM library and python to build reports? I'm looking for somebody to chat with about my project.

I have some data extracted from SAP and though the size is not relatively high lets say about 45000 line items. My excel keeps crashing anything i do with it 🙄! Any clue why it is happening ?

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

I work on a Mac and excel/sheets can’t handle the size of my data. MS access isn’t available on mac. What do I do 😭

I am continually struggling to understand how input complex equations like if functions and max/min. Anyone willing to chat briefly?

Is Tableau it Power BI better for dashboards? You cannot really do true dashboards in Excel.