Results 1 to 13 of 13

Filter out repeating values and apply formula on the second or 4th value only

Threaded View

  1. 11-11-2018, 07:29 AM #1
    Khalid.Noor
    Khalid.Noor is offline
    Registered User
    Join Date
    08-26-2014
    Location
    Riyadh
    MS-Off Ver
    MS Office 365
    Posts
    24

    Filter out repeating values and apply formula on the second or 4th value only

    Dear Experts

    I need help on a long list of transactions where I want to filter out those customers who have traded more than one time and then apply a formula only to the second or fourth transaction to calculate the discount value. Is it possible through Forumla or Macro will be better? Example data below

    Date Customer Number Revenue
    2-Nov-18 5005542746 1,147
    2-Nov-18 5005542746 640
    26-Oct-18 5005543078 3,967
    24-Oct-18 5005543080 270
    25-Oct-18 5005543080 102
    1-Nov-18 5005543080 270
    30-Oct-18 5005543080 11,161
    Attached Files Attached Files
    Last edited by Khalid.Noor; 11-11-2018 at 08:17 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Using VBA to apply values in a range to the filter in a Pivot Table
    By PFDave in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-06-2017, 09:17 AM
  2. Macro: Filter spreadsheet, then apply formula to results
    By RC-AMG in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-26-2015, 08:14 AM
  3. [SOLVED] make filter automatically re-apply when cell values change
    By tlacloche in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 04-02-2013, 06:44 PM
  4. How to apply filter in sheet on (Bold entries and values) only?
    By motivationalist in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-25-2012, 09:54 AM
  5. creating a repeating formula that doesn't show repeating values
    By cybershot in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 12-09-2010, 06:12 PM
  6. Counting # of rows with negative values and also changes when apply the filter
    By vcjj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-18-2010, 07:46 PM
  7. How can I filter a column to have only one instance of repeating values?
    By jchaney in forum Excel General
    Replies: 1
    Last Post: 01-13-2005, 03:38 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1