count

I'm trying to count the number of shifts of employees by looking up by employee. The shift data is on a seperate worksheet. I would like to use a formula that refers to the cell for each employee and then finds the corresponding name and counts the number of shifts in the rows and columns on...

Hello, I'm trying to figure out the code for counting multiple instances of different text in a column and displaying it all under one msgbox as a summary. So far I have only been able to get one count going with the below code; However I want it to check for 6 different colors count how...

Hi guys, Long time lurker, first time poster here. I'm working with results from a SharePoint survey that allows the respondent to check multiple boxes for a single question. In Excel, such answers are concatenated in a single cell with delimiters. For example, one answer could be...

Hello all, i want to extract data from column A to column B using formula. If number of characters after the hyphen is less than or equal to 4 then it has to be copied to respective B column cell. Refer example. Thank you. AB1HeadingExtracted...

I have a list of time off requests that are listed as date ranges (ie. 6/7/21 - 6/10/21 ) and I need to make a count of how many days off are requested for each date, ideally without having to manually input each date between the date ranges. So i want to be able to input 6/7/21 - 6/10/21...

i am creating a spreadsheet of stock trades. i have a field for the date the trade was opened and the date the trade was closed. Is there a way I can calculate the maximum number of trades that were open at one time. example SNo D/M/Y D/M/Y 1. open date...

Hi everyone, I'm migrating data from a legacy source information system to a new information system and want to confirm a variety of counts of values from the source data against the counts of the same values from the migrated data to ensure the counts match as a way to verify the records...

Hi guys, I need to create a short schedule about my backlog in my DB. As you can see I have 5 category ( PWHT ,MPI/PT, HT, RT, UT ) with a little backlog ( PWHT 4 , MPI/PT 0 , HT 7 , RT 16, UT 0 .) and I want to see only Backlog Lines from my DB. DB range in Sheet1 A2:CC367 and also after...

I have some data in one column (column B) as follows: Fruits Apple Orange Strawberry Snacks Chocolate Candy Ice cream Vegetables Spinach Beans ------------------------------------------- How would I do a numbering in column A that would exclude all blank cells and the text such as Fruits or...

Hi All, Sorry not good with excel formula, can you help me construct formula how can I count how many duplicates we have in Column B per Name (Column A)? Sample result should be: Rose - 1 (2 Red) Joy - 1 (2 Purple) Angel - 2 (2 Blue & 2 Red)

Hi Guys, I hope I can explain myself clearly . I have a user form, what I want to do is: Type a name, (let's think that I have 3 people call Jessica but with different last names), when I click in search, I want to be able to see displayed the 3 names Jessica inside the list box The sheet name...

Hello, I have a spreadsheet with error codes (column A) and timestamps (column B) . Every time there is an error, it is recorded and time stamped. I would like to write a macro that writes in another column (column D) the frequency of each error. I have filled column C with the distinct error...

Hi, I have an issue that I've been struggling with and I hope someone could please help me out. At work we have a standby rota, with one sheet per month. In each sheet there's a rota, and essentially it looks like this (but with each date of the month in it); Fri Sat Sun Mon tue Wed...

I have a Microsoft Worksheet that I would like to create three cells with answers to the following questions for the range A1:AA41. 1. What function do I use to count the number of cells in this range? 2. What function do I use to count the number of cells in this range with a formula? 3...

Hi, I have a schedule of employees, that works in shifts. But i want to count how many people are working between 07:00 and 12:00 and between 12:00 and 16:00 and between 16:00 and 20:00 How can i do that, the begin time is in a cell and the end time is in the cell next to it. see down...

Hi guys i count B:B but in this column available sum data, i want skip this data and not count this cells, just count numbers

Hi Excel knowledge gods! I can create basic macros but I am struggling with with this one! What I am trying to do is create a macro to copy and paste two sets of characters, in A1 is the the first number (number of shelves), this can be any number from 1 to 20 (possible more), and the second...

Hi, I'm trying to count how many weeks a specific Product has been active. The Product has been active if they have a value for that week. The value in Column B has to match a defined value (i.e. A, B, C, D - the data in cells B12-B15), and then the data from columns C to G have to be...

Hi All, Please see below. I need a formula (in yellow cells) that will return how many times the number is counted as well as the corresponding row returning a "yes". So for example, cell BA3 should be 6. Bit stuck with this one so any help will be appreciated. Thanks in advance, Mark

Dear All, I am looking for a simple formula, which will display the number of days in a year. Kindly help me. Name DOJ EOS 2013 2014 2015 Employee 1 01-01-13 08-08-15 364 364 220 Employee 2 05-04-14 31-05-16 270 364 Employee 3 15-02-14 16-04-15 319 106