Spreadsheet: 215036d1361233065-if-c-a-move-to-sheet-a-if-c-b-move-to-sheet-b-etc-medical-sample
Sheet: Main

Date | Payee | Service | Amount |  | Date | Service | Amount Rec'd | Total Cheque |  | Seq
Dec 6/10 | Shoppers | perscription | 41.91
Jan 26/11 | Dr. M | chiropractor | 37
Jan 31/11 | Dr. M | chiropractor | 37
Feb 1/11 | Dr. M | chiropractor | 37 |  |  |  |  |  |  |  |  |  | Hi
Feb 5/11 | Shoppers | perscription | 41.91 |  |  |  |  |  |  |  |  |  | Column D  >>  Make sure it the same word as highlight yellow cell
Feb 7/11 | Dr. M | chiropractor | 37 |  |  |  |  |  |  |  |  |  | perscription sheet A1
Jul 27/11 | Dr. M | chiropractor | 65
Jul 28/11 | [NAME] | massage therapy | 70 |  |  |  |  |  |  |  |  |  | Column K >>  it count 1 2 3 4  as you see word with number. =IF(C3="","-",C3&"_"&COUNTIF(C$3:C3,C3))
Jul 29/11 | Dr. M | chiropractor | 37
Aug 4/11 | Dr. M | chiropractor | 37 |  |  |  |  |  |  |  |  |  | Look in perscription sheet and other 4 sheet to dentist.
Aug 8/11 | Dr. M | chiropractor | 37 |  |  |  |  |  |  |  |  |  | column K call match =IFERROR(MATCH($A$1&"_"&ROWS(K$3:[NAME]:K,0),"")
Aug 9/11 | Shoppers | perscription | 31.76 |  |  |  |  |  |  |  |  |  | Then column A  =IF($K3="","",IF(INDEX(Main!A:A,$K3)="","",INDEX(Main!A:A,$K3)))
Aug 9/11 | Shoppers | perscription | 19.34 |  |  |  |  |  |  |  |  |  | Then copy a cross and down.
Aug 10/11 | Dr. M | chiropractor | 37 |  |  |  |  |  |  |  |  |  | Any more name will need new sheet and do the same as perscription sheet.
Aug 15/11 | Dr. M | chiropractor | 37
Aug 19/11 | PH&F | massage therapy | 67.8 |  |  |  |  |  |  |  |  |  | Cheer
Aug 22/11 | Dr. M | chiropractor | 37
Aug 25/11 | PH&F | massage therapy | 67.8
Aug 29/11 | Dr. M | chiropractor | 37
Sept 1/11 | PH&F | massage therapy | 67.8 |  | Nov 15/11 | massage therapy | 54.24 | 401.08
Sept 6/11 | Dr. M | chiropractor | 37 |  | Nov 15/11 | chiropractor | 20 | 401.08
Sept 9/11 | Dr. M | chiropractor | 37 |  | Nov 15/11 | massage therapy | 20 | 401.08
Sept 14/11 | PH&F | massage therapy | 67.8 |  | Nov 15/11 | massage therapy | 54.24 | 401.08
Sept 19/11 | [NAME] | massage therapy | 50 |  | Nov 15/11 | massage therapy | 40 | 401.08
Sept 23/11 | PH&F | massage therapy | 67.8 |  | Nov 15/11 | massage therapy | 54.24 | 401.08
Sept 25/11 | Shoppers | perscription | 42.75 |  | Nov 15/11 | perscription | 34.12 | 401.08
Sept 26/11 | Dr. M | chiropractor | 37 |  | Nov 15/11 | chiropractor | 20 | 401.08
Sept 26/11 | OH Dental | dentist | 218 |  | Nov 13/11 | dentist | 134.4 | 134.4
Sept 28/11 | Eye Care | optometrist | 132 |  | Nov 15/11 | optometrist | 50 | 401.08
Sept 30/11 | PH&F | massage therapy | 67.8 |  | Nov 15/11 | massage therapy | 54.24 | 401.08
Oct 5/11 | Dr. M | chiropractor | 37 |  | Feb 14/12 | chiropractor | 20 | 174.24
Oct 11/11 | Dr. M | chiropractor | 37 |  | Dec 15/11 | chiropractor | 20 | 283.04
Oct 12/11 | PH&F | massage therapy | 67.8 |  | Dec 15/11 | massage therapy | 54.24 | 283.04
[NAME] | Dr. M | chiropractor | 37 |  | Dec 15/11 | chiropractor | 20 | 283.04
Oct 19/11 | OH Dental | dentist | 354 |  | Nov 1/11 | dentist | 247.8 | 247.8
Oct 26/11 | Dr. M | chiropractor | 37 |  | Dec 15/11 | chiropractor | 20 | 283.04
Oct 28/11 | PH&F | massage therapy | 67.8 |  | Dec 15/11 | massage therapy | 54.24 | 283.04
Nov 2/11 | Dr. M | chiropractor | 37 |  | Dec 15/11 | chiropractor | 20 | 283.04
Nov 4/11 | Dr. M | chiropractor | 37 |  | Dec 15/11 | chiropractor | 20 | 283.04
Nov 10/11 | Dr. M | chiropractor | 37 |  | Dec 15/11 | chiropractor | 20 | 283.04
Nov 16/11 | Dr. M | chiropractor | 37 |  | Dec 15/11 | chiropractor | 20 | 283.04
Nov 18/11 | PH&F | massage therapy | 67.8 |  | Dec 15/11 | massage therapy | 34.56 | 283.04
Nov 23/11 | Dr. M | chiropractor | 37 |  | Jan 19/12 | chiropractor | 20 | 140
Nov 28/11 | Dr. M | chiropractor | 37 |  | Jan 19/12 | chiropractor | 20 | 140
Dec 1/11 | PH&F | massage therapy | 67.8 |  | Dec 15/11 | massage therapy | 0 | 283.04
Dec 5/11 | Dr. M | chiropractor | 37 |  | Jan 19/12 | chiropractor | 20 | 140
Dec 8/11 | Dr. M | chiropractor | 37 |  | Jan 19/12 | chiropractor | 20 | 140
Dec 12/11 | Shoppers | perscription | 61.96 |  | Dec 12/11 | perscription |  | 50.9 | direct
Dec 13/11 | Dr. M | chiropractor | 37 |  | Jan 19/12 | chiropractor | 20 | 140
Dec 19/11 | Dr. M | chiropractor | 37 |  | Jan 19/12 | chiropractor | 20 | 140
Dec 27/11 | Dr. M | chiropractor | 37 |  | Jan 19/12 | chiropractor | 20 | 140
Jan 3/12 | Dr. M | chiropractor | 37 |  | Feb 23/12 | chiropractor | 20 | 40
Jan 9/12 | Dr. M | chiropractor | 37 |  | Feb 14/12 | chiropractor | 20 | 174.24
Jan 11/12 | PH&F | massage therapy | 67.8 |  | Feb 14/12 | massage therapy | 54.24 | 174.24
Jan 13/12 | Shoppers | perscription | 49.61 |  | Mar 20/12 | perscription | 36.98 | 145.78
Jan 13/12 | Shoppers | perscription | 39.96 |  | Mar 20/12 | perscription | 29.37 | 145.78
Jan 16/12 | Dr. M | chiropractor | 37 |  | Feb 14/12 | chiropractor | 20 | 174.24
Jan 20/12 | Dr. M | chiropractor | 37 |  | Feb 14/12 | chiropractor | 20 | 174.24
Jan 25/12 | Dr. M | chiropractor | 37 |  | Feb 14/12 | chiropractor | 20 | 174.24
Jan 26/12 | Shoppers | perscription | 48.7 |  | Mar 20/12 | perscription | 42.45 | 145.78
Jan 30/12 | Dr. M | chiropractor | 37 |  | Feb 14/12 | chiropractor | 20 | 174.24
Feb 3/12 | Shoppers | perscription | 49.61 |  | Mar 20/12 | perscription | 36.98 | 145.78
Feb 3/12 | Dr. M | chiropractor | 37 |  | Feb 23/12 | chiropractor | 20 | 40
Feb 10/12 | Dr. M | chiropractor | 37 |  | May 14/12 | chiropractor | 20 | 402.44
Feb 15/12 | Dr. M | chiropractor | 37 |  | May 14/12 | chiropractor | 20 | 402.44
Feb 19/12 | Shoppers | perscription | 49.61 |  | May 14/12 | perscription | 36.98 | 402.44
Feb 19/12 | Shoppers | perscription | 61.96 |  | Feb 19/12 | perscription |  | 50.9 | direct
Feb 27/12 | Dr. M | chiropractor | 37 |  | May 14/12 | chiropractor | 20 | 402.44
Mar 2/12 | PH&F | massage therapy | 67.8 |  | May 14/12 | massage therapy | 54.24 | 402.44
[NAME] | Shoppers | perscription | 49.61 |  | May 14/12 | perscription | 36.98 | 402.44
[NAME] | Dr. M | chiropractor | 37 |  | May 14/12 | chiropractor | 20 | 402.44
[NAME] | Dr. [NAME] | form fee | 20
[NAME] | Dr. M | chiropractor | 37 |  | May 14/12 | chiropractor | 20 | 402.44
[NAME] | Dr. M | chiropractor | 37 |  | May 14/12 | chiropractor | 20 | 402.44
[NAME] | Dr. M | chiropractor | 37 |  | May 14/12 | chiropractor | 20 | 402.44
[NAME] | Dr. M | chiropractor | 37 |  | May 14/12 | chiropractor | 20 | 402.44
[NAME] | Shoppers | perscription | 86.84 |  | May 31/12 | perscription | 65.96 | 65.96
[NAME] | Dr. M | chiropractor | 37 |  | May 14/12 | chiropractor | 20 | 402.44
Apr 9/12 | Dr. M | chiropractor | 37 |  | May 14/12 | chiropractor | 20 | 402.44
Apr 13/12 | Dr. M | chiropractor | 37 |  | May 14/12 | chiropractor | 20 | 402.44
Apr 24/12 | Dr. M | chiropractor | 37 |  | Aug 16/12 | chiropractor | 20 | 429.44
Apr 27/12 | PH&F | massage therapy | 67.8 |  | May 14/12 | massage therapy | 54.24 | 402.44
May 3/12 | Dr. M | chiropractor | 37 |  | Aug 16/12 | chiropractor | 20 | 429.44
May 9/12 | Dr. M | chiropractor | 37 |  |  | chiropractor
May 14/12 | Shoppers | perscription | 86.84 |  | Aug 16/12 | perscription | 65.96 | 429.44
May 15/12 | Dr. M | chiropractor | 37 |  |  | chiropractor
May 18/12 | PH&F | massage therapy | 67.8 |  | Aug 16/12 | massage therapy | 54.24 | 429.44
May 19/12 | Shoppers | perscription | 30.38 |  | Aug 16/12 | perscription | 21.53 | 429.44
May 22/12 | Shoppers | perscription | 85.22 |  | Aug 16/12 | perscription | 64.67 | 429.44
May 22/12 | Shoppers | perscription | 85.82 |  | May 22/12 | perscription |  |  | direct
May 23/12 | Dr. M | chiropractor | 37 |  |  | chiropractor
May 28/12 | Dr. M | chiropractor | 37 |  |  | chiropractor
[NAME] | Dr. M | chiropractor | 37 |  |  | chiropractor
[NAME] | PH&F | massage therapy | 67.8 |  | Aug 16/12 | massage therapy | 54.24 | 429.44
[NAME] | Dr. M | chiropractor | 37 |  |  | chiropractor
[NAME] | PH&F | massage therapy | 67.8 |  | Aug 16/12 | massage therapy | 54.24 | 429.44
[NAME] | Dr. M | chiropractor | 37 |  |  | chiropractor
June 25/12 | Dr. M | chiropractor | 37 |  |  | chiropractor
[NAME] | PH&F | massage therapy | 67.8 |  | Aug 16/12 | massage therapy | 54.24 | 429.44
[NAME] | Dr. M | chiropractor | 39 |  |  | chiropractor
Jul 9/12 | Dr. M | chiropractor | 39 |  |  | chiropractor
[NAME] | [NAME] | massage therapy | 60 |  | Aug 16/12 | massage therapy | 20.32 | 429.44
[NAME] | Dr. M | chiropractor | 39 |  |  | chiropractor
[NAME] | Dr. M | chiropractor | 39 |  |  | chiropractor
Aug 2/12 | [NAME] | massage therapy | 60 |  |  | massage therapy
Aug 15/12 | [NAME] | massage therapy | 60 |  |  | massage therapy
Aug 22/12 | [NAME] | massage therapy | 60 |  |  | massage therapy
Aug 22/12 | Dr. M | chiropractor | 39 |  |  | chiropractor
Sept 6/12 | [NAME] | massage therapy | 60 |  |  | massage therapy
Sept 6/12 | Dr. M | chiropractor | 39 |  |  | chiropractor
Sept 10/12 | studentcare | private health/dental | 293.29
Sept 19/12 | [NAME] | massage therapy | 60 |  |  | massage therapy
Oct 3/12 | [NAME] | massage therapy | 60 |  |  | massage therapy
Oct 15/12 | [NAME] | massage therapy | 60 |  |  | massage therapy
Oct 17/12 | Dr. M | chiropractor | 39 |  |  | chiropractor
Oct 23/12 | DK, DC | chiropractor | 70 |  |  | chiropractor
Oct 24/12 | [NAME] | massage therapy | 60 |  |  | massage therapy
[NAME] | DK, DC | chiropractor | 35 |  |  | chiropractor
[NAME] | [NAME] | massage therapy | 60 |  |  | massage therapy
Oct 29/12 | [NAME] | massage therapy | 60 |  |  | massage therapy
Oct 30/12 | DK, DC | chiropractor | 35 |  |  | chiropractor
Oct 30/12 | Dr. [NAME] | form fee | 25
Nov 2/12 | WSM | physiotherapy | 87 |  | Nov 16/12 | physiotherapy | 69.6 | 556.8
Nov 5/12 | [NAME] | massage therapy | 60 |  |  | massage therapy
Nov 6/12 | WSM | physiotherapy | 53 |  | Nov 16/12 | physiotherapy | 42.4 | 556.8
Nov 8/12 | [NAME] | massage therapy | 60 |  |  | massage therapy
Nov 9/12 | Dr. M | chiropractor | 39 |  |  | chiropractor
Nov 10/12 | Shoppers | perscription | 101.75 |  | Nov 10/12 | perscription |  | 82.76 | direct
Nov 10/12 | Shoppers | perscription | 85.82 |  | Nov 10/12 | perscription |  | 67.34 | direct
Nov 10/12 | Shoppers | perscription | 63.88 |  | Nov 10/12 | perscription | 63.88 | 63.88 | direct
Nov 13/12 | [NAME] | massage therapy | 60 |  |  | massage therapy
Nov 13/12 | OH Dental | dentist | 319 |  | Nov 13/12 | dentist | 204.4 | 204.4
Nov 14/12 | WSM | physiotherapy | 53 |  | Nov 16/12 | physiotherapy | 42.4 | 556.8
Nov 19/12 | [NAME] | massage therapy | 60 |  |  | massage therapy
Nov 21/12 | BFC | orthotics | 450 |  | Nov 16/12 | orthotics | 360 | 556.8
Nov 26/12 | [NAME] | massage therapy | 60 |  |  | massage therapy
Nov 27/12 | WSM | physiotherapy | 53 |  | Nov 16/12 | physiotherapy | 42.4 | 556.8
Dec 1/12 | DK, DC | chiropractor | 35 |  |  | chiropractor
Dec 4/12 | [NAME] | massage therapy | 60 |  |  | massage therapy
Dec 7/12 | WSM | physiotherapy | 53 |  | Feb 5/13 | physiotherapy | 42.4 | 267.2
Dec 13/12 | DK, DC | chiropractor | 35 |  |  | chiropractor
Dec 14/12 | WSM | physiotherapy | 53 |  | Feb 5/13 | physiotherapy | 42.4 | 267.2
Dec 14/12 | [NAME] | massage therapy | 60 |  |  | massage therapy
Dec 19/12 | DK, DC | chiropractor | 35 |  |  | chiropractor
Dec 20/12 | DK, DC | chiropractor | 25 |  |  | chiropractor
Dec 21/12 | [NAME] | massage therapy | 60 |  |  | massage therapy
Dec 23/12 | DK, DC | chiropractor | 25 |  |  | chiropractor
Dec 27/12 | DK, DC | chiropractor | 25 |  |  | chiropractor
Jan 3/13 | DK, DC | chiropractor | 25 |  | Feb 5/13 | chiropractor | 20 | 267.2
Jan 4/13 | [NAME] | massage therapy | 50 |  |  | massage therapy
Jan 7/13 | [NAME] | massage therapy | 50 |  |  | massage therapy
Jan 7/13 | WSM | physiotherapy | 53 |  | Feb 5/13 | physiotherapy | 42.4 | 267.2
Jan 8/13 | DK, DC | chiropractor | 25 |  | Feb 5/13 | chiropractor | 20 | 267.2
Jan 10/13 | DK, DC | chiropractor | 25 |  | Feb 5/13 | chiropractor | 20 | 267.2
Jan 12/13 | DK, DC | chiropractor | 25 |  | Feb 5/13 | chiropractor | 20 | 267.2
Jan 14/13 | [NAME] | massage therapy | 50 |  |  | massage therapy
Jan 14/13 | DK, DC | chiropractor | 25 |  | Feb 5/13 | chiropractor | 20 | 267.2
Jan 18/13 | DK, DC | chiropractor | 25 |  | Feb 5/13 | chiropractor | 20 | 267.2
Jan 21/13 | [NAME] | massage therapy | 50 |  |  | massage therapy
Jan 22/13 | DK, DC | chiropractor | 25 |  | Feb 5/13 | chiropractor | 20 | 267.2
Jan 29/13 | [NAME] | massage therapy | 50
Jan 29/13 | DK, DC | chiropractor | 25
Feb 5/13 | Shoppers | perscription | 63.88 |  | Feb 5/13 | perscription | 63.88 | 63.88 | direct
Feb 5/13 | [NAME] | massage therapy | 50
Feb 5/13 | DK, DC | chiropractor | 25
Feb 7/13 | DK, DC | chiropractor | 25
Feb 11/13 | [NAME] | massage therapy | 50
Feb 12/13 | DK, DC | chiropractor | 25