excel formula help
6 TopicsExcel Formula
I’ve got an Excel workbook with multiple worksheets, each one having different numbers of rows and columns. Each worksheet has a variable called flag. I’m curious if there is some way for Excel to search the entire workbook for cases where flag=‘Flag’ and then highlight the row containing the value. thanks, Mike870Views0likes1CommentSpecific Excel Formula Help
Hey guys, I'm new here so sorry if this isn't a very tough question but how would i input a formula that would read, Knowing that in 1 case of QTR there are 4 sleeves and each sleeve has 15 units. Product Case Sleeve Unit Total Units QTR1(Pre Day) + 1 3 70 175 QTR2(Post Day) - 0 2 30 60 QTR3(Difference/End Day Total) = 1 3 10 115 I would need this on a scale for about 30 separate Items formatted the Same way as QTR but Independent, So any help with the formula or a Better Idea on how to format it to get the same result would be much appreciated!828Views0likes1CommentFind lowest price along with that vendor's name
Hello, On one tab, "BOM BRKDN", I have a materials list with several unique part numbers. On a second tab, "PRICING", is a list of all vendor quotes for all part numbers. I have a "Best Price" column (that seems to work fine) using the formula "=MIN(IF(E2=PRICING!$C$2:$C$10000,PRICING!$A$2:$A$10000))" (fyi; column E is unique part numbers on "BOM BRKDN" tab; column C is part number on "PRICING" TAB, column A is the price quoted on "PRICING" tab. I am trying to find a formula that will reference the best price and the part number to then find and auto-fill the associated vendor name (listed under column B on the "PRICING" tab). I've tried a variety of lookup formulas without success. Can someone please help?!?! Thank youSolved9.8KViews0likes2CommentsNeed help setting up options that correspond with numeric values
Im trying to set up a excel worksheet to use for product orders. In it I want to be able to select certain options that are set to automatically calculate the cost value. for example 1st option if chosen is $240 2nd option if chosen is $120 3rd option if chosen is $60625Views0likes0Comments