Re: Remove large numbers from string using VBA
This is a cross post 97hills,
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:Q3
What 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
Re: Print Number Of Copies Based On Cell Value
Quote from djtonton;701034Is there a way to say if there is a 0 there to skip and not print the page. Right now if there is a 0 i get an error 400
Try