finding information

klatlap

Well-known Member
Joined
Sep 1, 2004
Messages
597
hi all...can i use the formula to find information in a row between two cell references and what would i need to add.

thanks
=Mid(A2,Find(“-“,A2)+1,2)
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

tmischler

Well-known Member
Joined
Jun 17, 2004
Messages
669
can you elaborate a little, I am not sure I understand what exactly you want to do?
 

klatlap

Well-known Member
Joined
Sep 1, 2004
Messages
597
Re: finfing information
WEIGHT SELECTION.xls
OPQR
263
264Heavy:0:0-0-0.FirstUp:
265Cd50.00-3.00-53.00
2668.00Cd51.50-3.00
2672.00Cd52.00-3.00
RATING


The information i need to extract is in cells P265/Q266/Q267 now the cells that this information appears in can change so i wanted to find the Cd that appears always in the cell before the information i want....how best can i do this
 

klatlap

Well-known Member
Joined
Sep 1, 2004
Messages
597
Ok that seams to work...yes the Cd only apears in the row once like that.....will be adding this to my list of ever growing formulas for later reference....thanks again
 

Forum statistics

Threads
1,147,510
Messages
5,741,577
Members
423,668
Latest member
Audorin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top