finding cell value

  1. M

    Finding the adjacent cell value by referring the cell value and paste the content to next sheet.

    I have an order number such as 012, 013 in a separate sheet with details like <colgroup><col><col><col></colgroup><tbody> Order No 012 Status UserName Action Process Tom Await Approval Process Richard Await Approval Process Swetha Await Approval Process Michael Rejected Process...
  2. F

    Hello gang! I've got two question on how to 'find' some values in a specific data file, namely: - the '52-Week High' of the share price (highest valu

    Hello gang! I've got two question on how to 'find' some values in a specific data file, namely: - the '52-Week High' of the share price (highest value of the share in that specific year) - the value of the share price of the last trading day of that specific year (this isn't always 12/31/20..)...
  3. K

    Counting Value Cells Until blanks in row

    Hello, I am struggling with figuring out a way to count ALL the cells (blanks included) UNTIL the last valued cell is reached in a row, below an example of my spreadsheet and the count i would like to get. (goal 1 can be ref as cell A1) <tbody> goal 1 goal 2 goal 3 goal 4 goal 5 goal 6 goal...
  4. khawarameer

    Locating Cell Number

    Hello All, Take a look at these columns below; <table style="border-collapse: collapse; width: 134pt;" width="178" border="0" cellpadding="0" cellspacing="0"><col style="width: 67pt;" span="2" width="89"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    • Started by ipbr21054
    • Replies: 37
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    • Started by Moeey
    • Replies: 34
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    • Started by AllisterB
    • Replies: 30
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top