+ Reply to Thread
Results 1 to 44 of 44

Finding max value of each group and paste to another cell

Hybrid View

  1. #1
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,783

    Re: Finding max value of each group and paste to another cell

    The formulas in columns N through P have now been amended so that they begin with =IF(M3="","",... This prevents the #N/A from showing when there is no value in those columns. The formulas in columns M through P have been copied down to row 503 by selecting M7:P7 and double clicking the fill handle in the lower right corner of P7.
    Let me know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  2. #2
    Forum Contributor
    Join Date
    12-16-2013
    Location
    World
    MS-Off Ver
    Excel 2007
    Posts
    215

    Re: Finding max value of each group and paste to another cell

    Quote Originally Posted by JeteMc View Post
    The formulas in columns N through P have now been amended so that they begin with =IF(M3="","",... This prevents the #N/A from showing when there is no value in those columns. The formulas in columns M through P have been copied down to row 503 by selecting M7:P7 and double clicking the fill handle in the lower right corner of P7.
    Let me know if you have any questions.
    Thank you very much sir, no doubts about your code. now code is good.

  3. #3
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,783

    Re: Finding max value of each group and paste to another cell

    Quote Originally Posted by pvsvprasad View Post
    now code is good.
    You're Welcome and thank you for the feedback. If that answers your question, please select Thread Tools from the menu link above the first post on this page and mark this thread as SOLVED. I hope that you have a blessed day.

+ 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] (VBA) How Assign Column Cell To Corresponding Group, and Paste Group Cells into Groups WS?
    By eryksd in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-08-2016, 06:18 PM
  2. Vba - finding and cut/paste based on certain cell
    By Datagirl8472 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-24-2013, 02:25 PM
  3. [SOLVED] Macro to copy,paste and group information based on value in a cell
    By gullit in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-14-2012, 05:32 PM
  4. Macro to copy and paste into cell group in NXT ROW
    By L-plate in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-17-2011, 07:45 AM
  5. Replies: 10
    Last Post: 06-29-2007, 06:39 PM
  6. [SOLVED] Calculate,Copy, Paste Cell Group Macro Adjustments
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-28-2006, 11:50 PM
  7. [SOLVED] Calculate,Copy, Paste Cell Group
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-23-2006, 09:35 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1