+ Reply to Thread
Results 1 to 11 of 11

Arranging row wise data

  1. #1
    Forum Contributor
    Join Date
    03-11-2011
    Location
    Nepal
    MS-Off Ver
    Excel 2003-2019
    Posts
    830

    Arranging row wise data

    Hi All,

    This is modified problem that I am currently presenting & the previously presented similar type but was little different & vague that solved by forum contributor-himesh & I do not hesitate to admit it again.

    I have enclosed workbook in which I have shown the raw data i.e problem data with making very ease than previous and with expected solution.I want to arrange the data datewise in the manner that has been shown below in my workbook.Everything is self explanatory when anyone see the workbook.

    Hoping to get solved.

    With Best Rgds,
    Suresh
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: Arranging row wise data

    Hello Suresh ! Hope you are well!

    find the attached !

    Date.xlsx
    -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST

    More we learn about excel, more it shows us, how less we know about it.

    for chemistry
    https://www.youtube.com/c/chemistrybyshivaansh

  3. #3
    Forum Contributor
    Join Date
    03-11-2011
    Location
    Nepal
    MS-Off Ver
    Excel 2003-2019
    Posts
    830

    Re: Arranging row wise data

    Hi Himesh,

    Yeah I am fine and was expecting you.I was little busy in audit work.You have seen that I have removed "Remarks"part inorder to avoid complexity.

    I have seen the file.I think you have missed the expected result of column G20:G22.

    Hope you can do it this too.

    With Best Rgds,
    Suresh

  4. #4
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: Arranging row wise data

    Yes that also can be done but how did you arrived at G22(last Value) that's confusing


    Copy and Paste below in G20 (array entered ---ctrl+shft+Enter)
    =IFERROR(INDEX($C$2:$C$14,SMALL(IF($A$2:$A$14<>"",ROW($A$2:$A$14)-ROW($A$2)+1),ROWS($A$1:A1))+1),"") and drag down.

    Hope this Helps.
    Last edited by hemesh; 01-10-2014 at 12:11 PM.

  5. #5
    Forum Contributor
    Join Date
    03-11-2011
    Location
    Nepal
    MS-Off Ver
    Excel 2003-2019
    Posts
    830

    Re: Arranging row wise data

    The logic is that only those value of column C should be added if in Column B it does not contain 'Tax on Purchase' or 'Excise Duty' (whose values are in column C)

    If you have further confusion,then do let me know.

    I think you have understood well.
    With Best Rgds,
    Suresh

  6. #6
    Forum Contributor
    Join Date
    03-11-2011
    Location
    Nepal
    MS-Off Ver
    Excel 2003-2019
    Posts
    830

    Re: Arranging row wise data

    In addition to above as mentioned in my post #5,I have used your formula of post #4 only G20,G21 are ok but G22 do not produce the desired result.The logic u have asked I have explained in my post #5.Since this is the sample case, there might be much more G22 like case,hence accordingly you are requested to formula.

    I will be eagerly waiting for your response.

    With Best Rgds,
    Suresh

  7. #7
    Forum Contributor
    Join Date
    03-11-2011
    Location
    Nepal
    MS-Off Ver
    Excel 2003-2019
    Posts
    830

    Re: Arranging row wise data

    still waiting for the reply.

  8. #8
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: Arranging row wise data

    I am still thinking about how to go for that kind of logic ! Still in the process of different combination !

  9. #9
    Forum Contributor
    Join Date
    03-11-2011
    Location
    Nepal
    MS-Off Ver
    Excel 2003-2019
    Posts
    830

    Re: Arranging row wise data

    Oh! I thought u forgot.However,This 2day I have posted also in http://www.vbaexpress.com/forum/show...-data-datewise perhaps might be solved by VBA expert.

    I Hope u will come out solution.
    Last edited by paradise2sr; 01-16-2014 at 08:44 AM.

  10. #10
    Administrator arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,147

    Re: Arranging row wise data

    paradise2sr,

    Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

    Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

    Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  11. #11
    Forum Contributor
    Join Date
    03-11-2011
    Location
    Nepal
    MS-Off Ver
    Excel 2003-2019
    Posts
    830

    Re: Arranging row wise data

    Dear Arlu,

    I have corrected my mistakes and accordingly rectified it.

    With Rgds,
    Suresh

+ 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. Excel code to represent data from row wise to column wise
    By sreejeshc in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-12-2013, 03:45 AM
  2. [SOLVED] I want change the data row wise to coloum wise & coloumn wise to row wise.
    By satputenandkumar0 in forum Excel General
    Replies: 3
    Last Post: 12-20-2012, 08:34 AM
  3. Replies: 4
    Last Post: 08-01-2012, 09:50 AM
  4. Data row wise, formula column wise
    By Fred Smith in forum Excel General
    Replies: 4
    Last Post: 12-09-2005, 11:55 AM
  5. [SOLVED] Delete row wise duplicates & colomun wise simultaneously excel
    By Dipankar in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-06-2005, 09:05 AM

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