Hi all,
I am new to the forum and a novice in excel so please bare with me and I appreciate your help.
I have a large list of product codes for which I need to make some product descriptions. The codes are fairly descriptive such as TN135CLC, which has the CLC standing for Cyan Low Capacity. I have been able to do this on a single basis but I want a formula that will cover all options such as TN135MLC (magenta low capacity) at the same time. Some of the codes have no C or M after. All possible options which come after the rest of the code are,
C (Cyan), M(magenta), K(black), Y(yellow), CLC(cyan low capacity), MLC(magenta low capacity) etc
The current formula is;
=IF(ISERROR(SEARCH("CLC",D29))," ","cyan low capacity")
In trying to add additional IF's, or add a VLOOKUP table of the codes and relivant text I am not able to get this to work.
Can someone help me complete this as it will save hours of work in typing out product descriptions?
I was not able to send a sample of my data so I hope the above is enough.
Many thanks
David
Hello i have an excel that looks like the attachment and i have been given a task to make this as much automated as follows, like running a query and finding everything that involves the Shop X and a given week, and secondly making it as a template so that can be sent through email at a given date and time each week.
Please help me
If anyone knows a program that can handle this event management better than excel is also welcome
Hi,
I suspect this is a bit of a noobish question but I can't get my head around how the formula works so I would appreciate it if someone could explain it to me. The first part to an IF formula on a report I use at work is:
=IF( T2<>"" ,value if true, value if false)
Cell T2 only contains two types of data, either five alpha characters (e.g. SALES) or seven alpha numeric characters (e.g. A123456).
What is the formula looking for and how do the two types of data affect its (True/False) decision making?
Thanks
Snook
Hi,
Can anyone help me convert this excel formula to mathematical equation or simple explanation please. I just want to understand how those cells related.
Any help is much appreciated. Thanks very much.
Andre
Hi,
I have several suppliers and each has a few commodities.
A sample you can see in table A.
Table A
Date Supplier Commodity Sum $
1.4.2011 A Fish 1,251
2.4.2011 A Meat 8,247
12.4.2011 B Veg 1,020
3.4.2011 C Comfit 258
8.4.2011 B Veg 547
5.4.2011 A Fish 891
20.4.2011 A Fish 953
9.4.2011 B Fruits 745
Total 13,912
What I want is to get a summery table that sum the amount of purchase from each supplier divided to the commodity type. You can see it in table B.
Table B
Supplier
A Fish 3,095
A Meat 8,247
B Veg 1,567
B Fruits 745
C Comfit 258
Total 13,912
I hope I and the data are clear.
Using windows xp Excel 2003.
Thanks,
Amnon
Hallo all competent knowledge carrier!
I have the following Problem:
I have a table which looks like this:
mat.group:_564
supplier:_____alpha____beta____cesar____dora
volume:_____2000_____1500____3500____1200
mat.group:_789
supplier:_____beta____cesar_____gamma
volume:_____2000_____1500_____3500
mat.group:_123
supplier:_____alpha____cesar_____dora
volume:_____5000_____2000_____1000
Now I would like to make an extract which shoul look like this:
Supplier:_______alpha____beta____cesar____dora_____gamma
mat.group:
564___________2000_____1500____3500____1200________0
789______________0_____2000____1500_______0_____3500
123___________5000________0____2000____1000________0
Total_________7000_____1500____7000____1200_____3500
That means, that I want to present all existing suppliers, without doubling them in order to have an clear array with total volume per supplier.
Could somebody help me please? I tried it per excel-function "IF", but the if-loops are limited....
Can somebody please post me a solution by excel-function via macro?
much thanks in advance
What does it mean when you see an Excel icon (the big X) with a small clock below the X? I'm using Excel 2003. Thanks for your help.
I have produced a form that will be used by other users and I would like to
think that when the user puts the cursor over a cell it pops up a text box
that explains what data is to be entered or explains the outcome
Hi,
I have a spreadsheet which has:
Col A: Supplier
Col B: Units Sold
Col C: Total Sales
In column D, I need to show the commission for the total sales. However it varies on the supplier and units sold. Ie supplier 1 there is 20% commission regardless of units sold, supplier 2 is 25% commission for 1-49 units and 20% commission for 50+ units.
Is there an easy formula I can use to calculate the commission in column D?
Many thanks in advance!
Hello.
I have a list of part numbers (appr. 8000 rows) and on some parts there are shortages in our warehouse.
I am using this function to find how many shortages there are all together:
=SUMPRODUCT((MaterialController=$A7)*(Demand>0)*((Stock<Demand)))
This works very well and gives me how many shortages the current Material Controller in cell A7 have.
The Material controller have a number of Suppliers connected to him. I would like to summarize how the shortages are divided between all the suppliers connected to the current material controller.
Lets say that the current material controller have 10 suppliers and only 5 of them have shortages. How can I get that only 5 suppliers are affected from my part list? I have a defined range called SupplierNumber where all suppliers are listed by part number.
The table contains these column names:
PartNumber
MaterialController
Demand
Stock
SupplierNumber
Does anyone have any suggestions how I can get this information with a simple function?
If I have not been precise, please ask and I will contribute with more information.
/Anders
VLOOKUP in Excel.