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.
Posts by Ingo_Ingo
-
-
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?
-
Re: IF FORMULA that divide 1 column to 2
Ok then,
L1 =LEFT(G1,FIND("x",G1)-1)
M1=RIGHT(G1,LEN(G1)-FIND("x",G1)) -
Re: IF FORMULA that divide 1 column to 2
Hi,
No need formula, try Text To Column.
Date --> Text To Column -->Next --> Other (here put "x" Without "") and from Destination, choose L1 --> Finish