finding

  1. G

    Finding each cell where a style is used

    Hello, I am trying to find each location where a style is used and SELECTIVELY replace that style (one by one, manually) with another style. I am not trying to replace all usages of one style with another style, blindly. Is that possible? Many thanks. Keith
  2. A

    Finding the text and moving Next cell

    Hi All, Thank for your support for learning for VBA I have a small problem, I find the text and copy 7 cell in the Active sheet but code not move Next finding. This my code Cells.Find(What:="Date", After:=ActiveCell, LookIn:=xlValues, LookAt:=xlWhole, SearchOrder:=xlByRows...
  3. J

    Finding Date in Listview

    Hi, Is there anyone that can show me how to find in listview control column 2 the earliest date and populate it in textbox 1, and the latest date into textbox 2. Thank you to anyone that can help me.
  4. D

    Finding value of last cell in list

    I need to find the value of the last number in column A and add 1 to it. Can someone help me with the vba for this please? Thanks, Dave
  5. F

    last used row in column C equals last used row in column E

    Hello everyone, I could use some help in finding last used rows. If C1 is >0, I need the last used row in column C to equal last used row in column E. thanks
  6. L

    finding the second match if the first value is equals to zero

    how to get the second value if the first value is equals to zero across multiple sheets?
  7. K

    IFs, ANDs, and BUTs

    Need help finding a formula for the following conditions: If AV14="Yes" AND AV76 is a number, then enter the value of AV76, BUT if AV14="No" then enter "N/A". Any help would be appreciated. Thank you!
  8. K

    finding last row (that is visible) starting from the first row (that is visible)...

    never mind... I got it! apologies for the 'false alarm' ;) how do I find the last visible row when starting from the first visible row, but BELOW a certain starting point? So in the example below, the code would need to locate the first visible row that is below row 3, and down to the last...
  9. K

    Finding and getting text from a lot of cells in a row

    Hi, I am trying to find a text in a row, A9:AP9 where this value is: id: "bf00c6e0-b7a7-11e7-a8e6-0a580a2c491b" I then want to take the value between the " (speech marks) and return it to another cell, so I would have bf00c6e0-b7a7-11e7-a8e6-0a580a2c491b Is this possible? I have tried all...
  10. C

    how to quickly fill in a table

    I have an Excel table of that format number | description | weight 1 | weight 2 | number | description | weight 1 | weight 2 I have to fill in data by finding the number and manually fill in weight1 and weight2 Is there a way I could just make the data entry quickly instead of finding...
  11. R

    VBA Finding keywords then copying nearby rows of variable length

    Hi, thanks in advance for any help, I realize it's a lot. I'm trying to take one sheet and upload data to another. The task is: 1) Find Keyword 1 on Sheet 1 2) Skip 3 columns and copy a varying number (based on source sheet) of columns with data; below would be 4 columns (111 thru 114) but it...
  12. S

    Look up a value and display the score

    hi am finding it hard to explain it but it should be easy in the example <tbody> A B C D E F G 1 Score Level Score Level 2 10 AA 10 =????? 3 20 BB 15 AA 4 50 CC 18 AA 5 100 DD 25 BB 6 200 EE 70 CC 7 </tbody>
  13. 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 >...
  14. D

    finding the date 3 months later, 6 months later, and 12 months later

    please help im trying to find the date 3 months later, 6 months later, etc.....taking into account working/business days only ....i already have a table set up for holidays
  15. L

    I want to Print the userform

    I am finding confused for printing the userform. Please help for creating excel VBA code for printing userforms.
  16. W

    Formula Help

    Hi I wondered if anyone could help me with what I am finding to be a rather tricky situation which I am sure someone can help with though! I have extracted information from another system (not excel) into excel and the cell states 8/2/19 and the data is 02/08/2019 17:00:00. I need to...
  17. JenniferMurphy

    Finding the last row in or length of a passed range

    Given pratings, a range, I can find the absolute range address, the number of rows and columns, and the number of the first row and column. ?pratings.address $D$5:$G$14 ?pratings.rows.count 10 ?pratings.columns.count 4 ?pratings.row 5 ?pratings.column 4 Are there expressions...
  18. A

    Finding the lowest value variable

    I have 5 variables in that stores row numbers, I need to find out which has the lowest value and then put that value into another variable is there a way to do this without creating a horrible nested IF ELSE .?
  19. R

    Finding averages inside a named 1-dimensional range

    I have a named range (rYvalues) which is a singe column. It can be of variable length (7 to 365). If I want to take an average of a continuous section of that 1-dimensional named range, say average positions 50 to 99, how might I be able to do that? I've been all the web on this one and...
  20. K

    Finding Averages Across Multiple Columns That Meet Certain Criteria

    Hi, I want to be able to work out averages from a spreadsheet like below, across multiple columns. So for example, all of the averages from KWB1** to get a value f 2 returned, and then KWB2** to get what would be 7 in this example. Is there a way of just doing that in one formula? <tbody>...

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