• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to delete cells in between for matching that row with another row

S

subhapratimdas

New Member
Column A Column B Column C

PLU SalVal SalVal

EGG ROLL 435.00 435

DB. EGG ROLL 80.00 80

PANEER ROLL 50.00 50

CHK.ROLL 825.00 825

EGG CHK ROLL 450.00 450

D.EGG.D.CHK.ROLL 50.00

MUTTION ROLL 120.00 50

EGG MUTTION ROLL 70.00

CRUNCHI FISH FRY 810.00 120

FISH FINGER 160.00 70

CHK BIRIYANI 1120.00

CHK.BIRIYANI SPL 250.00

MUTTION BIRIYANI 1710.00 810

MUTT.BIRIYA.SPL 260.00 160

VEG BIRIYANI 70.00 1120

CHK.KASSA 75.00 250

CHK.MASALA 150.00 1710

CHK.CHAMP 75.00 260

CHK.BHARATA 90.00

CK.RES.BUTT.MSLA 130.00 70

CHK.TIK.BUT.MSLA 130.00 75

CHK.HUNDI MASALA 100.00 150

CHICKEN PATILA 120.00 75

CHK.TAWA MASALA 240.00

MUTTION KASSA 240.00 90

MUTTION MASALA 85.00 130

MUTTION CHAMP 425.00 130

MUTTION HNDI MSL 250.00

MUTTION DO PIAZA 90.00 100

PRAWN MALAI CURR 200.00

VEG PULAO 120.00

KASHMIRI PULAO 140.00 120

CHK.BOTI PULAO 355.00 240

MUTT. BOTI PULAO 480.00 240

BASMATI RICE 160.00 85

ALOO DUM 100.00 425

CHANNA MASALA 60.00 250

MIXED VEG 65.00 90

VEG JHAL FREJI 70.00

VEG KOLAPURI 80.00

KADAI VEG 75.00

PNR.BUTT.MASAL 240.00

KADAI PANEER 255.00 200

MUSHROOM MATAR 90.00

CHK.TANDOORI (F) 1440.00

CHK.TANDOORI (H) 170.00 120

CHK.RESMI KEBAB 285.00 140

CHK.TIKA KEBAB 475.00 355

CHK.MALAI KEBAB 240.00 480

TANDOORI ROTI 168.00 160

TND.ROTI WIT.BUT 220.00 100

BUTTER NAAN 200.00

LACHHA PARATHA 240.00

DAL TARKA 120.00

EGG TARKA 50.00 60

DAL MAKHANI 195.00 65

GREEN SALAD 25.00 70

CHK STEM MOMO 300.00 80

CHK.PAN FR MOMO 90.00 75

DRUMS OF CHICKEN 140.00

CHICKEN LOLLYPOP 700.00 240

CHK CLEAR SOUP 50.00 255

CHK.SWT.CORN S. 55.00

VEG CHOWMIEN 200.00

EGG CHOWMIN 180.00 90

CHK CHOWMIN 750.00 1440

MIXED CHOWMIEN 290.00 170

VEG FR.RICE 250.00 285

EEG FR.RICE 60.00 475

CHK FR.RICE 375.00 240

MIX FRY RICE 1300.00 168

SZECH.CHK.FR.RIC 80.00 220

SZECH.PR.FR.RICE 240.00

CHILLY CHIKEN 1170.00 200

GARLIC CHICKEN 180.00

MANCHURIAN CHK. 475.00

SWEET N SOUR CHK 200.00 240

SZECHUAN CHICKEN 200.00

CHK.B CORN MUSH 110.00 120

CHK.I HOT GARLIC 100.00 50

CHICKEN IN OYSTR 110.00

SZECHUAN FISH 420.00 195

CHK.LUNCH 400.00

M.WATER 1LTR 15.00 25

M.WATER 2LTR 25.00

COLD DRINK 600ML 297.00 300

COLD DRINK 2LTR 128.00 90

COLD DRINK 200ML 36.00 140

ICE CREAM 10 259.00 700

GRAVY 10 30.00


50

55


200

180

750

290


250

60

375

1300


80


240


1170


180


475

200

200

110

100

110


420


400


15

25

297

128

36

259

30

----------------------------------------------------------------


You can copy and paste in excel workbook the above part. I want to delete cells in between of Column C so that I can match Column B and Column C if its correct or not.


Regards

Subha
 
Hi,


what is present is ColumnC?? In ColA is present Name of dishes, In colB are there prices but what is in col C?? Can u upload a sample file??
 
Column C

435

80

50

825

450


50


120

70


810

160

1120

250

1710

260


70

75

150

75


90

130

130


100


120

240

240

85

425

250

90


200


120

140

355

480

160

100


60

65

70

80

75


240

255


90

1440

170

285

475

240

168

220


200


240


120

50


195


25


300

90

140

700


50

55


200

180

750

290


250

60

375

1300


80


240


1170


180


475

200

200

110

100

110


420


400


15

25

297

128

36

259

30


This values are there
 
Hi subhapratimdas,


It's not exactly clear from your post what's going on? But if your data is in separate columns A, B & C and you want to see which prices match in B & C, if you put this in column D then copy down


=IF(B2=C2,"matched","not matching")


If I'm totally wrong then look here


http://chandoo.org/forums/topic/posting-a-sample-workbook
 
Hi,


I need to match blank cells in between in Column B and Column C. In Column C ie between 450 and 50 there is one cell which I have to delete, similarly 50 and 120 so that I can find corresponding to Column B the values in Column C


ie D.EGG.D.CHK.ROLL 50.00 is showing in Column B

but in Column C blank cells.


If I delete one cell and shift cell value up then I can compare D.EGG.D.CHK.ROLL in Column B 50.00 and Column C 50.00. So my issue is that instead of deleting cells manually one by one in column C. Objective is that once all blank cells in column C gets deleted without changing sequence or order, I can then only match the value in Column B.


Example Column C Values

435

80

50

825

450


50


120

70


Regards

Subha
 
Hi subhapratimdas,


I have worked out a file. Here is the download link:

http://dl.dropbox.com/u/60644346/subhapratimdas%2C.xlsx


I hope it will help solving your problem, but for future kindly consider upload a sample file (Read third sticky post on forums home page), It would have been easier for you to understand solution with your own data worked out... :)


Regards,

FASEEH
 
You must log in or register to reply here.
Back
Top