Search results

  1. A

    Excel Autocorrelation Calculation

    Hello Experts, I'm working with vibration sensor data in Excel, and I've got a set of 1808 values representing samples from one shaft rotation. I'm not an Excel or stats expert, but I've heard about Autocorrelation, which should give values between +1 and -1. I want to use Autocorrelation to...
  2. A

    Formula to lookup value based on criteria

    Hello, I have been on this my whole day. Still could not figure out a way. I need to lookup some values from a list for instance: A2:A10 based on the value of B2. The value of B2 must be the sum total of the filtered values. In the below example, I need to filter out the data whose sum total...
  3. A

    Looking For 3 Different Formulas

    Hello, Need some assistance for the following questions. Q1: example table below, what I need to do is count the number of 'yes' total, except the first section, which is yes if any (so max 1). Red yes Blue yes Green no Banana no Apple no Orange yes triangle yes square no circle no so for...
  4. A

    Custom Cell Format

    URGENT!!! Hello All. I need to be able to add a number to a cell and then have the following format be automatically filled in. The only other option I would have is to type it all in on all 1300 rows or copy and past and change the number on all 1300 rows which both do not sound like fun at...
  5. A

    Copy Selected (Protected - Column Headers) Rows/Cells Into Body Of The Email As Image

    I am a new learner/novice on VBA. The following VBA code from this forum works great to copy unprotected rows/cells to paste as image into body of the email. Thank you. I want copy and paste selected multiples rows (cells) into body of the email as shown below. e.g. from practice work book, i...
  6. A

    First And Last Value

    i want first and last value(time) of a given date in two different columns im able to get the first value through vlookup with a helper column, but have trouble with the last value Result Helper Column Name Date Time in/Out First Value Last Value Young|45068 Young 22/05/2023...
  7. A

    Extract Data To Build A Report... Golf-Skins Report; Multiple Winners Per Hole

    Help! I have golf data (scores hole-by-hole); but I need to use it. I seek to create a skins report by selecting data based on criteria hole-by-hole. The skins report would consider: 1 par per hole, if there are no lower scores on that hole. Or... Up to 2 birdies per hole; if there are no lower...
  8. A

    Match

    Match
  9. A

    M

    Hello
  10. A

    To

    Pivot table
  11. A

    Compare

    Best Regards.
  12. A

    File

    Hello,
  13. A

    Format

    Hello
  14. A

    Hello Everyone!

    I am Andy Teal. I teach Statistics at a college. I need some Excel suggestions and that's why I am here.
Top Bottom