name2

Hi, Im trying to figure a way to count ColumnB (dates) or unique values only for single name in column A (names) so the result for would by name1 = 2 name2 = 2 <tbody> name1 1/1/2000 name1 2/1/2000 name1 2/1/2000 name2 1/1/2000 name3 2/1/2000 </tbody> any help is much appreciated..

Hi friends, I have one issue which I cant resolve. So I have sheet1 with vertical list: Name Name1 Name2 Name3 Name4 etc... And I have to link it on sheet2, but on every fourth cell and horizontal. So it should be in link like: Name (empty cell) (empty cell) (empty cell) Name1 (empty cell)...

I have the following entries in a spreadsheet: <tbody> Employee Date Days Total Balance Used Balance Booked Balance Remaining Name1 0 Name1 0 2 0 0 2 Name1 4/25/2019 1 20 3 0 17 Name1 4/26/2019 1 20 3 0 17 Name2 0 Name2 0 Name2 1/2/2019 1 37 3 32 2 Name2 1/3/2019...

Hi, I need your help to find any idea how to handle the task. Let's say - I have the sheet with 500 rows (from the top) where column A contains Name and column B and column C contain some numbers. row1: name1, 2, 3, row2: name2, 1, 1, row3: name3, 3, 1, row4: name4, 2, 4, and so on. I need...

Hi everyone, I would appreciate if anyone can help me with theis code: Sub pairs() Dim sh As Worksheet, tb As Long, c As Range, sVal As Range Set sh = Sheets(1) 'Edit sheet name tb = sh.Cells(Rows.Count, 1).End(xlUp).Row For Each c In sh.Range("B2:B50") 'Assumes header row...

Good Day, I have a data table like below starts from A2 to C19 Is it possible to ruffle those datas randomly by clicking a command button? Every column will remain with same datas ony their rows will be changed... Thank you... <colgroup><col span="3"></colgroup><tbody> NAME1 1 1 NAME2 1 2...

Hi All, I have an initial list. I would like to be able to display this initial list 3 times sorted on different criteria each time as below: <tbody> initial list list sorted on column C list sorted on column D list sorted on column Total <tbody> Rank Name C D Total 1 name1 10 20 30 2...

Hi, I have a large spreadsheet with 2 columns A and B <colgroup><col style="width:48pt" width="64" span="2"> </colgroup><tbody> Name1 Apple Name1 Apple Name1 Apple Name2 Apple Name2 Apple Name2 Peach Name3 Pear...

hi all members how to make automatique calculations of differents names in same column when we have alot of names same, what i want not sum of name1 and sum of name2, what i want sum of different name <tbody> name1 name1 name1 name2 name2 name2 name2 name2 name3 name3 name4...

I would like to calculate the total hours for M, T, W, Th, F, Sa, Su Can you please help with the formula? I was able to get the total hours for each employee but haven't been able to figure out how to break it down per day. I have the following table: <tbody> Employee Name Employee Number...

I have names in a table listed multiple times and I want to create a formula that numbers each one and starts over numbering when the name changes. name1 1 name1 2 name1 3 name1 4 name1 5 name2 1 name2 2 name2 3 name2 4 name3 1 name3 2

I have a spreadsheet with 20,000 rows of data that I need to get the earliest and latest dates into one row. Example, for Shop1 I would need the start date to be 01/01/2018 and the end date to be 05/04/2018 recorded in a column to the right so I can sort by that column and get rid of data that...

Hello, Need help with the following - I have the following information in one sheet <Sheet1> in Column A. This list is very long (1000s of names). I need this information to move to <Sheet2> in this format - Name (Column A), Designation (Column B), Company Name (Column C). The <Useless Info>...

Hi All, I have a matrix that I need to update based on a table I have. Essentially, if the table shows completion, I'll need the matrix to be updated with the corresponding date of completion Example, I have this table: <tbody> Name Training Completion Name1 Training1 3/13/2016 Name1...

Hi All, I have a matrix that I need to update based on a list I have. Essentially, if the list shows completion, I'll need the matrix to be updated with an "x" Example, I have this table: <tbody> Name1 Training1 Name2 Training2 Name2 Training4 Name3 Training3 Name4 Training1...