LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 76
Default Delete Void Invoices

Some invoices only have 2 lines when they are void but some have several
lines. How would I set up a formula to remove all of the lines except the
one that says receipt when the invoice if void?
2650741 $1,484,822.62 Inv $1,484,822.62
2650741 -$222,724.00 Receipt -$222,724.00
2650741F -$1,262,098.62 Finance -$1,262,098.62
2650741 -$1,484,822.62 Void -$1,484,822.62
2650741F -$1,262,098.62 Finance $1,262,098.62
2650741 $222,724.00 adj $222,724.00
Donna


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
invoices tofimoon3 via OfficeKB.com New Users to Excel 6 March 25th 09 01:47 PM
How do I place the word VOID across and Excel spreadsheet? Roberta Henning Excel Worksheet Functions 3 August 5th 08 05:42 PM
best way to do invoices jtietz93 Excel Discussion (Misc queries) 2 February 10th 06 05:47 PM
Invoices Lunk Excel Discussion (Misc queries) 0 June 2nd 05 07:17 PM
No void value skipped by graphic chart news.tin.it Charts and Charting in Excel 3 March 6th 05 04:27 PM


All times are GMT +1. The time now is 01:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"