Nov 07 2021 11:01 PM
Apr 22 2022 05:20 AM
Jul 22 2022 08:40 AM
Hi! I have an excel question. I have a workbook that has several sheets. My main sheet(sheet 1) is what I’m trying to place a formula in. I want cells in column B to auto fill with data from sheet 2 IF column A in sheet 1 matches column A in sheet 2. However, it’s possible that there are more than one matching column A.
so column A has contract numbers in sheet 1.
Sheet 2 has
column A - contract numbers
Column B - contract types
it is possible that one contract can hVe 2 different type so I want both types to auto fill on sheet 1
Oct 10 2023 02:22 PM
I am trying to do a calculation to say on how many days in a month a bar is open
see data, Bar1 was open 2 in Jan, 3 in Feb. Bar2 was 1 in Jan 2 in Feb
on excel 365
Oct 10 2023 02:40 PM
You can create a pivot table based on the data. Make sure to add the data to the Data Model when you create it.
Add Month to the Rows area, Bar to the Columns area and Date to the Values area.
Then change the summary function for the Values field to Distinct Count in the Value Field Settings.
See the attached demo workbook.
Oct 16 2023 02:45 PM