# Arranging row wise data

1. ## 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

2. ## Re: Arranging row wise data

Hello Suresh ! Hope you are well!

find the attached !

Date.xlsx

3. ## 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. ## 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.

5. ## 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. ## 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

8. ## 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. ## 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.

10. ## Re: Arranging row wise data

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).

11. ## Re: Arranging row wise data

Dear Arlu,

I have corrected my mistakes and accordingly rectified it.

With Rgds,
Suresh

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

#### 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