abcd

  1. S

    Conditional formatting based on multiple columns

    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...
  2. E

    Index match function

    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...
  3. S

    VBA Solution Find and Replace

    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
  4. L

    Consolidating Data

    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...
  5. Guzzlr

    Add TExt to a Cell With a Number

    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 =...
  6. L

    Excell project is giving me a hard time

    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...
  7. S

    VBA to compare two cells values

    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...
  8. W

    Trim

    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...
  9. K

    VBA alternative for MAXIFS (to use with non Office365 versions)

    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...
  10. K

    CountIf Different Tab

    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...
  11. E

    Verify if there's a date in a range.

    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.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top