Search results

How may final digits do you ever expect to have? maybe 10 in further future, now it is five, but I want to find a method to just extract numeric digits from right side, till reach to text...I dont want extract numeric digits if exist in middle or at the beginning. Why is it not a consistent...

Ok UMH...Waiting for u NOTE: See the attachment, which I add a new column on Inventory Sheet next to Location named "Type".

Thanks again Mr. unmarkedhelicopter, 1. The formula for extracting numbers from right is correct but unhappily if there is a number in the middle of the string then there is an error, I dont need the numbers in the middle of the sting, just i need the numbers occurs at the right side till reach...

Thanks much Mr. unmarkedhelicopter, and all others, I am really sorry I could not explain more, because I had a really bad internet speed... the problem is fine and wonderful and working well Mr. unmarkedhelicopter.... About the extracting number, it is not fixed something like five, maybe the...

yeah you are right for the script (UDF), but anyway I would solve that...thanx for recommendation... So what you want is as follows :- You type in "Herat" into "Max of Property" Sheet A6 You then want to consider ALL rows from sheet "Inventory" where the value in column N is "Herat" You want...

First Thanks all, See the attachment now, hope everything should be clear...

On "Max of Property" sheet (what is that supposed to mean ?) You enter Herat for row 6 an then enter "22", by this am I supposed to infer you want SPSS/AFG/HRT/FA00022 looking up on sheet "Inventory" ? yes then you want the quantity available for SPSS/AFG/HRT/FA00022 ??NO, I need Property...

Thanks... Here is the attachment with data and explanation

see...Herat and Kabul are the Unique name "Location" from inventory sheet, and I need the formula "MAX but previous column" according to these Locations... I know there are no more data, they are not needed... as you see in "Max Of Property" Sheet, there is a column "Max of Property Number"...

Thanks for replying... As you see in the attachment there are two sheets 1. Inventory 2. Max Of Property 1. Inventory: "Property Number" is what we enter, but "Extracted Number" is a formula column, which just extract the number from right of the "Property Number" column, but here I entered...

if anyone could help me through this plz...

Mr. unmarkedhelicopter... Sorry I cant implement your posted formula on my problem, plz see the attachment ...

thanks very much, I will implement this method on my problem and then post the result....Thnaks anyway...

Hi. Suppose I have two colums, one is Location and Second is Quantity, and I want the maximum but not like the max quantity display instead I like the Location of the Max is displayed... Location--Quantity A --10 B --20 C --10 A --30 B --15 A...

Thanks for replying, ,I did but nothing happen...but the shift key works in Access. I wonder how made that example

Hi, I have downloaded an excel example, when I open it just I see a user form, nothing else. 1. How can I enter inside the Excel or VBE? 2. How can I remove the Start up userform? Thanks

Thanks for the tips, but I dont have much data,I shall be very glad, if u plz guide me how to handle that...

Hello every body, I have four text boxes and a subform on a form, the text boxes is suppose one is for the First Name, Last Name, Country, and Average and the subform includes all the data... Wanted: I want to filter the subform data at the ONCHANGE event of each text box, suppose if some want...

Thanks much for that...

Dear all, I have a bount combo box, I want that if the typing word is not in the combo, Appropreite message appears in the After Update event... How it is possible?