comparison

  1. K

    VBA: column comparison and sheet comparison with delete

    Hi, new to the forum and have been researching different VBAs to use. I've tried to combine a few so I am not sure if this can be done or maybe I shouldn't bother with this whole scenario as it could be too long. Here is my scenario: I have a master sheet of data. I used a VBA to compare my...
  2. L

    Best Approach to create a column to display the comparison between current lap time and previous lap time?

    Hello guys, I have been trying for a few days to come up with the best approach to creating a column that will follow these rules, as yet without success: - It will read in a previously calculated cell *let us call it F41 for later reference* that has worked out the previous best lap time...
  3. R

    Equal number and date being treated as different when comparing them

    Hello and thank you for any help you can provide. So, I have a userform I am using to edit a main database, It looks like this: I am using Vlookup to fetch details in the userform when a serial number is input. The code is as follows: Private Sub txtSerial_AfterUpdate()...
  4. C

    Comparison match for text

    I am trying to do a comparison of uneven columns of text to see if the other column contains a match. I want to make it not case-sensitive. I have tried doing an IF statement. Is there anything else you recommend?
  5. kelly mort

    Finding words match in a string or an array

    I don't want to break any rules here. And if I am doing so then I am sorry. I have posted a quest here https://www.mrexcel.com/forum/excel-questions/1109916-vba-code-compare-contents-two-textboxes.html Which looks like what I am posting again. But this seems a bit clearer. After re-looking at...
  6. G

    Fill right VBA is skipping over a column

    I have a command button that adds a column to a table. The table has formulas that need to be filled to the right with each new column added. Here is the vba that I have been using to achieve this: Dim ws As Worksheet, oLo As ListObject Set ws = Sheets("Competitor Comparison") With ws Set...
  7. S

    Comparing text in 2 different cells

    Hi It is easy to do the above as per https://exceljet.net/formula/compare-two-strings. My question: Can one do such a comparison without extra spaces in one cell being counted in the comparison? In other words, if the only difference between the 2 cells is an extra space in a sentence, I...
  8. H

    IF column comparison + 1 more criteria

    Hi, I am performing two IF criteria: 1) Compare Column B to Column A for a matched cell value 2) Column C contains any value I want "NO" to be no cell match and any value found I have the below so far: Many thanks
  9. B

    Player Comparison Formula

    Hello, everyone! I have a workbook for you all to look at so you can better understand my problem. In the 'Player Comparisons' worksheet, a list is used in A1 that helps find the closest comparisons to the player selected and puts the names of those comparisons in cells D2-D6. In the 'Players'...
  10. A

    Comparison Failing

    I feel this should be a very easy solution, but I am finding myself struggling. For p = 70 To 73 If tpgo = "<" Then pdd = format(ws_sbase.Cells(p, 2), "h:mm am/pm") If pdd >...
  11. K

    If value in list, then assign label

    Hi All, Good morning/afternoon/evening depending on where you are in the world. I've run into a little problem on this fine Monday morning! I feel like its a really easy one and I'm just being an idiot, or the weekend hasn't quite worn off completely I'm not sure! I've tried looking online and...
  12. P

    Simpler Conditional Row Creation

    I'm currently working on a project intended to simplify the user interface for a table. This table can run in the hundreds of rows and as-is these need to be entered manually line-by-line. We want to create a system in which the table will fill most of its lines based on the information of a...
  13. R

    MACRO HELP NEEDED: Complex comparison, text coloring, and reporting between an old and new sheet.

    I have a complex macro in my mind that I want to build, but such little macro experience that I just can't build it alone. One workbook. Three sheets. Several hundred rows, but only columns A through G. Sheet1 "Old" Sheet 2 "New" Sheet 3 "Final" Sheet 4 "Report" Each workbook has the exact same...
  14. M

    Compare + Find + Write Equation

    Hello, I got stuck with my computation. I will try to explain the problem but it is rather complicated to do so. The first task is to compare values for each cell in two columns in Sheet2 with another values in Sheet1. (e.g. if sh2.A1=sh1.B:B and sh2.C1=sh1.F:F then...) If those match, in...
  15. J

    timevalue() # value error

    have sheet with now() in A1 and timevalue(9:00") in A2 need to perform an operation in other cells based on a comparison of the two cells. the following formula returns the #value error. =IF(RIGHT(A1,9)>A2,B4,C6) any help greatly appreciated
  16. J

    Perform operations on a cell range inside a formula

    I need to compare to columns using index/match but round each value before comparison. Could create a dummy column but that is very cumbersome and ugly. is there a way to perform an operation on each cell value before the comparison =match(round(a6,1),Sheet!A6:A1000) I need...
  17. O

    How to compare data in two columns that are not written in the same way

    Hello, I have a datasheet with 35000 datas in one column and I have to compare it with another colomn that contain 10-15 lines. The problem is that the way they are written are not the same. For example in one column I have : Microsoft Visual C++ 2008 Redistributable - x86...
  18. R

    VBA: Compare Cell Contents to Multiple Arrays

    Hi Excel Experts, I need some help creating VBA code that will accomplish a very repetitive task. I have 2 sheets of data, I need to compare Sheet 1 to a specific range on Sheet 2 and where a value from that range on Sheet 2 appears in the PIO String (column 3) it needs to be removed from the...
  19. R

    Any recommendations to speed up VBA comparison function? [long]

    Wrote this mass of VBA code in order to compare sentences for equality. Any recommendations for speeding it up? Not looking to use other programs (though it would be easier) as VBA is the only current one I have access to. Looking for better algorithms for assignment issue as well as removing...
  20. P

    Cricket players comparison

    Is there any way to compare the players of 2 cricket team in excel basis of their last performance, ground, team etc? I have csv files of each player downloaded from ESPN stat guru.

Watch MrExcel Video

This Week's Hot Topics

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
Top