abcd

Hi In my sheet, columns a, b, c and d can contain either "yes" or "no" - the rest of the columns contain text I want to colour the row red if any of abcd contains a no I want to colour the row green only if all of abcd contain yes I then want to count how many rows are coloured red I then...

Dear All, I could like to use INDEX MATCH function to obtain a specific data that i need from Raw Data. How can i implement the formula? Please refer to example below. Thank you all. Raw Data (Sheet 1):- <colgroup><col span="3"></colgroup><tbody> Master Account# Buyer Account Seller Account...

If cell in column A contains x, and cell in column E contains y, change text in column E to abcd. Example, if cell in Column A contains "LOSANGELE", and cell in column E is "IY", then change "IY" to "abcd". Thanks in advance

Hi All! I have a spreadsheet with more than 15K lines of data. This is the product of combining about 10 different versions of the same spreadsheet (there was no real version control before I started working on it). The data are grouped by content in cells in column A (VBA code to insert blank...

For Each cl In Range("G7", Range("G" & Rows.Count).End(xlUp)) If cl.Value <> Null Then cl.Value = "ABCD " & Range("F") End If Next cl Hello All, I'm attempting to add the letters ABCD to each cell in column G, starting at G7, with the number in column F Example: F7=2567, then G7 would =...

Hello everyone I have an excell project to do but having hard time. A friend of mine recommended this forum saying there are excell magicians here so I am asking for help I have 15 numbers for example 111122223333444. I need to add a certain number ABCD to that number for ex 4433. so i created...

Hi, I am looking to have a spreadsheet that is updated from a database, and then someone manually types in what has been completed, I would like to have a macro where it would compare the values between two cells then output the what is missing. For example, in cell A2 I have "ABCD" then in B2...

HI Master. I am wondering how to trim a row and remove part of a cell's information My two queries below. Query 1 Before After Customer Customer ABCD (1234) ABCD AAAAAAA (321) AAAAAAA xxxxxxxxxxxxxxxxxxxxxxxx Query 2 Before...

Hi, Although I frequent Mr. Excel to figure out resolutions for my VBA issues, this is my first post here coz after racking my head on this repeatedly I have not gotten anywhere :( The data scenario: I have over 15,000 rows of data in a format similar to the sample table below: <tbody> S.No...

Hello, I have a workbook with two tabs. [Tab1] contains a list of 50 ID numbers [Column A] and then a start date [Column B] and an end date [Column C]. <tbody> A B C D 1 ID START DATE END DATE # of Reports 2 ABCD 10/4/2017 3/31/2018 4 3 ZYX 10/24/2017 3/31/2018 1...

I need a formula that find the position (if there's one) of a date in a range (rows range). <tbody> 100 ABCD 3/3/2017 12,1 #$% </tbody> = " MATCH(ISDATE(A1:A5)=TRUE)"=3 Thanks.