Posts by Ingo_Ingo


Re: VBA Excel Advanced Filter
Quote from Binning;727257[INDENT].... i think you've got the comma and the decimal mixed up.[/INDENT]
39,640.86 is correct. 39.640,86 is not. excel will recognise the first number as a number, but the second it will identify as text.
You're wrong!
In Europe decimal symbol is "," not "." and yes that number is: 39 thousand 6 hundred 40 euro and 86 cents.saya
Excel sees that number as text. Where are those numbers? by copy paste? from another program? 
Re: Searching for numbers in one workbook & marking the number in another workbook.
Try this:
=IF(ISERROR(MATCH(S2;[woorkbookA.xlsm]Blad1!$J$1:$J$13;0));"";"x")
maybe your regional settings.

Re: unique values from multiple arrays
Hallo XOR LX
OP wants to list only numbers that are unique in both columns.
Example: number 1 will not be listed as is found in the first column and the second column. Number 2 will be listed as it is only once in both columns.
Number 10 will not be listed, as is found 2 times in the first column etc ... 
Re: help inventory list
Why not use punctuation???

Re: Remove large numbers from string using VBA
This is a cross post 97hills,


Re: Stock calculation
You want a VBA code or formula? Tell me if VBA code is OK.

Re: Lookup column value and find values in corresponding row
Batman,
Excellent. Thanks a lot.

Re: Lookup column value and find values in corresponding row
Bump

Re: Lookup column value and find values in corresponding row
Mumps,
Thanks for the code but in C3:Q5 data are entered by centralizing data from other sheets. I need to be able to view the C8:C12 week number that corresponds to the top 3 sales (or more) of D8:D12. It all depends on what you choose in B8.
example:
If B8 is the "C" in D8: D12 will be top 3 sales related range C5:Q5
If B8 is "A" in D8: D12 will be top 3 sales related to range C3:Q3What is displayed in C8: D9 is how I want to be (with formulas or VBA code).
Obviously if the B8 is  let's say "A"  I have other values in C8: D9.Sorry I did not explain clearly.

Hi,
My request is to help me find a formula (or VBA code) to show my three weeks with the largest sales customer A, B or C.
I found something similar here
Lookup column value and find nth values in corresponding row
but the requirements are different.See attach.
Thanks advance. 
Re: Combo box in excel
Try this:


Re: IF FORMULA that divide 1 column to 2
In O1 =IFERROR(IF(C1="";0;VALUE(MID(C4;(FIND(" ";C4;6)+1);FIND(" ";C4;FIND(" ";C4;6)+1)(FIND(" ";C4;6)+1))));0)

Re: IF FORMULA that divide 1 column to 2
400396,
You must be more explicit. Where? what column? what formula to which you refer? I can not guess. My crystal ball tells me that you want to change the formula in column N. If so put this formula in N1
=IF(RIGHT(C1;1)="P";2;IF(RIGHT(C1;1)="C";1;0))
and "drag" down to where it's needed. 
Re: IF FORMULA that divide 1 column to 2
In general you can not add apples to oranges, ie to add numbers with letters (some of the numbers were seen as text). Errors are more, but I rebuilt formulas in the file. Look at the formulas and study them so that you can understand in the future.
See the attached file. 
Re: IF FORMULA that divide 1 column to 2
Upload a file (obviously no confidential data) to see what type of data you have.

Re: IF FORMULA that divide 1 column to 2
If this formula is ok
=VALUE(MID(C1,(FIND(" ",C1,6)+1),FIND(" ",C1,FIND(" ",C1,6)+1)(FIND(" ",C1,6)+1)))Try this:
=IF(ISNUMBER(C1),VALUE(MID(C1,(FIND(" ",C1,6)+1),FIND(" ",C1,FIND(" ",C1,6)+1)(FIND(" ",C1,6)+1))),0)

Re: IF FORMULA that divide 1 column to 2
Yes, you can. Did you tried and is not working?