fast

Hello everybody, Whenever I open a PowerPoint document, the function "Embed fonts in the file" is turned off: Is there any way in which I can make it so this is automatically turned on? Thank you! :) Best regards, Jyggalag

NOTE* Please skip until the next line highlighted in bold if you're not interested in seeing how my setup functions. Thank you! Hello everybody, I am currently managing a minor inventory consisting of 101 unique goods. Currently my excel sheet looks like this: To briefly explain the sheet...

Please help, Super simply: I have stock on column G and minimum stock on column F. I want to highlight my stock if it is below the minimum stock through conditional formatting: As you can see, I have made the correct conditional formatting that if my value is equal to or less than F2...

Hello everybody, I am currently managing a stock (inventory management) portfolio in Excel. In this, I have my current inventory quantity in column I and two columns in column J & K which I can use to subtract & add amounts from my quantity, so: Column I = Current quantity Column J = Enter any...

Hello everybody, I am currently having some problems with my excel spreadsheet. In short, I have a list of materials in my "Order form" sheet 1 and I have all the hard data in a hidden sheet called "Products" (sheet 2). Currently, I have just set the fields in my "Order form" sheet = the...

Hello Mr. Excel Community Since 5 hours I am struggling with the following code, which I'd love to expand. I simply want to mimic the built in ctrl + F search tool via an Input Box, adding the feature to stay in row/column (ActiveCell) while looking for the name (letters not numbers). Sub...

Hello I am looking for a free and fast way to manipulate large amounts of data (GigaBytes). I think Powershell is the most appropriate as it comes with Windows and it is fast. Do you have any other alternatives? As for Powershell, can you help me please with a script that will read the lines...

This is pretty fast, is there any quicker? Thanks. LR = [match(2,1/(l21:l<>""))]

Hello everyone, does anyone know the shortcut keys to access the com add ins? I know the shortcut to access add ins in Alt+T+I but is there one for com add ins? I toggle between add ins frequently as some clash with others and need to be disabled so it would be great if there was a fast way to...

Hello! I have been fighting and trying to find a way to set multiple cells to 0 value without VBA/macros but no luck yet. Reason why it needs to be done without VBA/macros is because worksheet will be used with mobile or tablet so excel version on those don't support for VBA :mad:. Worksheet...

I've been looking for some time for code to perform the simple operation of flipping numbers back and forth between positive and negative. As an accountant I've tried many, many versions. Some work quickly, but balk when it interacts with text - error #Value . Others are super slow as it...

Good afternoon, Hope you are doing well today. I have Excel 2010 with a sheet with over 250k rows. Each row has a column letting me know whether a part was "Good" or "Reject". I want to delete all rows with "Reject" in a very fast manner. How can I accomplish this? Thanks, have a great day.

Hi, I am trying to put two separate formulas into one, but I am being given a #VALUE ! error in return. Every single one of them is working fine on it's own, but together there seems to be something wrong. Code 1 Code 2 Consolidated Anyone has any ideas? Thanks

Hi Usually i use this type of formula to do this. Is it any way or method to do a same thing which is fast and ease. I'm working with a large number of this. thank you

Hi , I have the look up table below <tbody> A B C D E STATUS YES YES GOOD NO NO FAST BAD </tbody> <tbody> </tbody> i have a table of data below and i need to pick the correct status based on the rules in the look up table. <tbody> name A B C D E STATUS craig yes yes no no...

Working on metadata for a music library. I'm having problems with an IF formula, there are five possible outcomes for the cell named "Tempo": Unspecified Very Fast (131+BPM) Fast (111-130BPM) Medium (90-110 BPM) Slow (0-89 BPM) In my formula, S2 is the BPM value of each song =IF(S2<90,"Slow...

Hi, I need help figuring out the best way to use the data in sheet 2 to populate all the fields in sheet1. Ultimately, sheet1 will be converted to PDF when all the information is gathered. I'm struggling with making it look good. I'm Currently using If Statements for the yes no questions...

Hi all, i'm usually good with formulas but this ones got me crazy, i'm trying to add up a bill because i think my network provider is pulling a fast one: I'm trying to add a these sort of formats: http://imgur.com/a/U2FyN Thanks for your help guys!

I have real quick question what's the shortcut in excel to copy down really fast, lets say I have 40000 rows and I can't just select all but I need to copy down ? I know there is a shortcut? Thank you!

This isn't a problem, just curiosity. I've got a reasonably large Excel forecast model (10Mb). I recently rebuilt the model to FAST standards, so it now uses a ton of SUMIFS over 1200 cell ranges and these feed a lot of other sheets. Calculation is Automatic. At bottom left, where it says...