Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #9  
Old 09-07-2018, 12:48 AM
Marcia's Avatar
Marcia Marcia is offline How to return data from a list of daily transactions into a different format Windows 7 32bit How to return data from a list of daily transactions into a different format Office 2007
Expert
How to return data from a list of daily transactions into a different format
 
Join Date: May 2018
Location: Philippines
Posts: 554
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

Could we go back to this problem? As you suggested, I inserted column V in table 1 indicating if the major account is Sundry or Column. I have also simplified the location of Sundry columns in the CHDJ sheet. What's the formula for putting the sundry major accounts of each check in the CHDJ? Please help me find peace about this. I've tried several formulas but with unsatisfactory result. Problem areas were painted yellow.
Attached Files
File Type: xlsx CKDJ (2).xlsx (79.4 KB, 11 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
converting daily data to annual jahan Excel 1 05-30-2017 07:11 AM
How to return data from a list of daily transactions into a different format Return List Based On Specific Value Helmszee Mail Merge 1 04-12-2016 02:30 AM
Return Value from Drop-Down List bartleby Excel 0 01-20-2016 07:45 PM
How to return data from a list of daily transactions into a different format Excel Validation Feature to Return Items from a List summerabc Excel 1 01-16-2015 04:37 AM
How to return data from a list of daily transactions into a different format Combining daily S.M.A.R.T data in a meaningfull sheet (2 problems) Vitolio Excel 1 07-10-2013 08:58 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:47 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft