Decrease numbers in data range to equal specific number

Posted on 2011-10-20
Last Modified: 2012-08-13
I have a data range in a row which sum = 229.  I need to decrease the number to sum = 184.  The data range of numbers is different in each I have 23, 45, 33, 44..ect. ..How would I be able to decrease each cell by percentage so that the end result would produce 184
Question by:TechMonster
    1 Comment
    LVL 50

    Accepted Solution

    You can multiply every number by 184/229

    If the sum is variable make that


    You could calculate that number in any cell, copy that cell, then choose data range and then right-click, choose "Paste Special" option and use "Multiply" option > OK > ESC

    regards, barry
    regards, barry

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    VBA Excel Gantt 1 30
    copying from excel to word 2 30
    Using Pop Up Calculator in Excel 4 29
    Adding to a VBA? 6 34
    How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
    Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
    This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
    This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now