+ Reply to Thread
Results 1 to 2 of 2

Finding Same Value across multiple excel

  1. #1
    Registered User
    Join Date
    01-24-2023
    Location
    Malaysia
    MS-Off Ver
    2019
    Posts
    1

    Finding Same Value across multiple excel

    This is an optimization report from an expert advisor (EA) automation for trading. The data is quite large, as it goes up to 3300. I have it separated by month in different Excel sheets. The image shown below is a sample of the header for one month - September.

    I am interested in finding the same sets of settings that repeat themselves in different months so that I can utilize them in my trades. I would like to use the columns starting from K to S. I need assistance with two different methods:

    Method 1: For example, if I choose the first row data in September where K=90, L=100, M=95, N=95, O=60, P=70, Q=45, R=70, S=95, I would like to check if it repeats in the months of October, November, and December. Can you guide me on how to do this?

    Method 2: Similarly to Method 1, but with an additional parameter where the value in Column C must be greater than 100 in the months of October, November, and December. Can you assist me with this as well?

    I apologize if I have not provided all the necessary information. I am new to this and would greatly appreciate your guidance.
    Attached Images Attached Images

  2. #2
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    2,830

    Re: Finding Same Value across multiple excel

    1. Are you looking to use VBA (a macro) or formula?
    2. From Method one, you say, "If I choose the first row..." - how do you "choose" the first row?
    3. An image is not very helpful. Please think about attaching a sample file with just enough data to be useful, and include a mock-up of your desired results. (Please read the yellow banner at the top of the page.)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] finding missing numbers in multiple excel sheets
    By kswapnadevi in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-31-2018, 01:23 AM
  2. [SOLVED] Finding Duplicates Across Multiple Worksheets in Excel
    By MSafir in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-15-2017, 07:37 PM
  3. Finding Multiple Criteria in an Excel Book
    By alex.williams in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-12-2013, 08:40 AM
  4. Replies: 5
    Last Post: 10-01-2013, 02:34 PM
  5. Excel 2010 Finding multiple values for HLookup or VLookup
    By Helmut Kirchner in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-13-2013, 12:30 PM
  6. [SOLVED] Excel 2003 finding average with multiple spreadsheets
    By dodger34 in forum Excel General
    Replies: 6
    Last Post: 12-26-2012, 05:16 PM
  7. [SOLVED] Finding common data in multiple columns and rows in Excel
    By sparham in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-12-2005, 01:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1