Tagged With "drop"

I used to be pretty good at Excel but don't have to use it as much as I used to. That being said, unless things have changed, I don't think that radio buttons or drop down menus can generate a value that can be used in a formula. If the variables are few, then if/then might work. If the variables are great, then try VLOOKUP or HLOOKUP formulas.

Hey Art, here's how - In Excel add the choices you want in the dropdown to a column of cells. Go to the Data tab and select Data Validation menu and data validation. In the popup window select the setting tab and in the allow dropdown select list. Enter the range of cells where you entered the choices earlier. You can enter additional text from the other tabs and then OK. Voila' a dropdown in Excel. Be careful if you reference the contents of the dropdown as it will result in the index value...

thanx for this, I'll give it a go later

I tried this and it works!!! Amazing the things you can learn on this site. Thanks Rick!

awesome worked here also, now how about when I pull an item from the drop down that a price will populate in the next column? Any takers on this?

So expanding on the original solution. Add another column of data next to the choice column you used for the dropdown with the corresponding prices for each choice. Next go to the formulas tab in the ribbon and select Name Manager -> New. Enter "Data" in the range "Name" field and select the range of cells with all the choices and prices in them for the "Refers To" field and OK. Finally in the cell next to the dropdown field enter this formula. =vlookup(E5,Data,2,false) E5 in this example...

What does "drop out colour send" mean?

Drop Out Color Send When scanning in B&W, users can choose to NOT capture a specific color -red, green, or blue - from a scanned page. This is useful when extracting data from forms, or to enhance OCR scanning accuracy by narrowing the range of color characters to be interpreted as editable text.

Can you expand on Distributed Scan management? I am use to the idea of creating one touch buttons or templates on the copier control panel to enable scanning or workflows. How is this different? Or is it just marketing?

With out much ballyhoo, Ricoh introduced two new A4 (can't scan, print, copy or fax 11x17) Black MFP's. The Ricoh SP4510SF and the MP 401SPF.    It's my understanding that the difference between the two devices is that the SP4510SF...

Can anyone help with this?  I'm working with MS 365 and would like to add drop down lists for products that would then auto populate the price.  I went here and followed the instructions however it is not working ...

I had scheduled the last stop of the day about a mile from my home. For almost three years I've been calling, emailing and dropping off production information for a net new account. Three years with nothing, I was beginning to think that the company...

Many times in my selling career I get caught up with just trying to meet my quota instead of putting meat on the table. Yes, I'm anal about hitting those monthly and quarterly and yearly numbers, and yes, I have been known to sacrifice GP just to...

Canon reports sales & profit decline - reported third-quarter net income of $245.6 million - posted total revenue of $8.05 billion down 6.2% - stock has dropped 4% in the last 12 months - net profit fell 43% from a year earlier to 26.52 billion yen ($244.1 million) - operating profit decreased by 43.7 percent year-over-year to ¥38.4 billion. - Income before income taxes decreased by 29.9% to 47 billion yen - overall sales of Canon office MFPs decreased slightly compared with the same...

TOKYO — Toshiba Corp forecast on Friday a 15.7% drop in annual operating profit compared with expectations of a small rise in profit, even as a recent portfolio overhaul helps the industrial conglomerate limit the impact of the coronavirus outbreak. It forecast profit of 110 billion yen ($1 billion) for the year through March 2021, down from 130.46 billion yen a year earlier. The outlook compared with the 136.71 billion yen average of 13 analyst estimates compiled by Refinitiv. Since a...