abc1

Hi there, I am trying to use the COUNTIFS funtion to highlight duplicate rows. Here is an example of my data: _____A _________B _____C_______D 1 UserID _____Name __Licence__Duplicate? 2 ABC1 ..............Joe ........1CL** ......=COUNTIFS(A:A,$A2,C:C,$C2)...

I need some help from the experts please. I have a list of materials, which varies in length by day. I need to explode this list into individual line items that repeat based on Qty, kind of like a reverse Pivot Table. This list is typically hundreds of line items per day. For example...

Hi I wanted to copy a column from one sheet and transpose it to another in merged cells but could not get the code to work. So, I thought instead I would get the destination row to take the cell value twice. I.e. Source Data abc1 abc2 abc3 Destination Data abc1 abc1 abc2 abc2 abc3 abc3 Can...

Hey guys, I'm trying to copy data from multiple sheets into the main "Mastersheet". Assume Name is at Cells.A1. Mastersheet <tbody> Name 1A 1B 1C 2A 2B 2C 3A 3B 3C A1 ABC1 y1 x1/z1 ABC2 y2 x2/z2 ABC3 y3 x3/z3 A2 A3 A4 </tbody> Worksheet name "A1" <tbody>...

Hi, thanks for all the help here! I have a row that can contain cells with values of 'ABC1', 'ABC2', ... 'ABC9', and also blank. (This row also contains integer values, I want to ignore these) I want to sum up all the ABCX numbers, so if I have in Row 1: ABC1 ABC1 ABC7 To sum up, this is easy...