+ Reply to Thread
Results 1 to 6 of 6

How to include a duplicate output in an excel report

  1. #1
    Registered User
    Join Date
    11-17-2020
    Location
    Srilanka
    MS-Off Ver
    Office 365
    Posts
    4

    How to include a duplicate output in an excel report

    Hi,
    Forum Q.jpg
    I need to have a duplicate of the output highlighted in yellow if i have the ref&col to be the same again. As of now, if the ref&col has already given the output once, i dont get it again but i need the output to be repeated in the order that is on the left.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    1,157

    Re: How to include a duplicate output in an excel report

    I'm not following you. Where is the input data and what is the data you want? Can you tell us "Based on this data, I'd like to see this output"?

  3. #3
    Registered User
    Join Date
    11-17-2020
    Location
    Srilanka
    MS-Off Ver
    Office 365
    Posts
    4

    Re: How to include a duplicate output in an excel report

    Column A and B is my input and using some formulas I have fetched Output in Columns D,E,F & G.
    the input and corresponding output highlighted in yellow is one example.
    if i put the same input again in Col A and B, i should be able to see the same output again.

  4. #4
    Registered User
    Join Date
    11-17-2020
    Location
    Srilanka
    MS-Off Ver
    Office 365
    Posts
    4

    Re: How to include a duplicate output in an excel report

    Forum Q.jpg
    this is the output that i want to be shown in red

  5. #5
    Valued Forum Contributor
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    1,157

    Re: How to include a duplicate output in an excel report

    How do you get that output from just 2 columns of input. Output1 shows 117.7 - how to do you get that from just an input of 1065.8? same questions for output2 and output3? And why do you show 3 rows of data in the output when there is only 1 row of input? What am I missing?

  6. #6
    Registered User
    Join Date
    11-17-2020
    Location
    Srilanka
    MS-Off Ver
    Office 365
    Posts
    4

    Re: How to include a duplicate output in an excel report

    Hi all, Apologies for the back and forth. This attachment should have all the updated formulas that will help you understand my request better.
    Please help me get a solution for this. Thanks much in advance
    Attached Files Attached Files

+ 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. Replies: 2
    Last Post: 09-12-2020, 11:34 AM
  2. Trying to duplicate conditional formatting used in report n access to excel sheet
    By axsprog in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-27-2020, 09:05 AM
  3. Replies: 1
    Last Post: 02-07-2015, 04:41 AM
  4. Automation Process of Schedule Report Output and Report Check Score Card !
    By ozman86 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-19-2014, 10:28 AM
  5. [SOLVED] do not include total in pivot table report
    By cfinch100 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-24-2014, 08:57 AM
  6. [SOLVED] Excel report summarised output
    By Zaid in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-04-2013, 03:58 AM
  7. [SOLVED] How do I manipulate pivot table report to include percentage of?
    By KRUEMJ-Needs some help in forum Excel General
    Replies: 2
    Last Post: 01-30-2005, 10:06 PM

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