easy

Hi Mrexcel I'd like to scale columns of number to be TOP=100 BOTTOM = 0 Is there an easy way? Thxs <tbody> 113 99 118 84 TOP 100 5 9 -8 16 BOTTOM 0 </tbody>

Hi Guys, can anyone tell me what's wrong with the following construction, please? All three components work individually so I assume it's the way I have put them together that's the problem. In the below, only the first component works...

Hi I am using the following SUMIF('01012019'!$I$1:$I$1000,"GRID",'01012019'!$F$1:$F$1009) I need to pick up info from each tab on my sheet dating 01012019 to 31012019. my question is : Is there an easy way to do this ?? Or would I have to go into every sheet. Thanks

I am trying to convert an 11 page Pdf document to excel and have the formatting work correctly. If anyone knows of an easy way to do this I would appreciate it. Thank you, Beth

Hi All, i have about 50 workbooks all in the same folder. In each workbook tab 3 is named "commercial" is there an easy way to extract just this tab/worksheet from each in to another workbook. Kind regards DM

I have a list of data from Jan 2014 - Dec 2018. Is there an easy way to use conditional formatting so all the Jan,Mar,May,Jul,Sep,Nov are filled Gray while Feb,Apr,Jun,Aug,Oct,Dec are Blue? Thanks!

Hi, I would like to ask for some help with Excel. Im not into VBA and i have to merge 2 big tables (150X500) in a way i presented in picture below>> Is there any easy VBA code to do it or another option how to get there?

Hey all, I'm making a spreadsheet for the users on my Discord server, so they can identify fanartists who accept commissions, and calculate which prices they want. https://docs.google.com/spreadsheets/d/1skPQhzpjgW2dogUINUCV47Pv-TBFdcKxdZ9NsMdjObY/edit?usp=sharing I'm providing a google...

Dear all, I have a table (I have added a table with pictorial values) with quite a bit of data, under there is another table divided by countries with INDEX and MATCH, as you can see not every country has values, I would like to have only non-empty countries in the list. According to the...

I need help with what should be easy formula but I can't get it right. I have the following figures: <tbody> 2 2 0 0 10 0 0 </tbody> The average is 2, but I have a separate Formula which is a minimum of 2.5. How do I replace the zero values with whichever is higher of the average or the...

I need to a formula which takes the 00:30 number from the 00:00, the 00:00 from the 00:30 on the next day and so on. Basically I don't want to include the 00:15 or 00:45 in my formula when I take one number from the other. I sure there is an easy way. <colgroup><col></colgroup><tbody>...

I have a line graph with a trend line and I was wondering is there a somewhat easy way to determine the beginning and end points on the trend line?

Hello! Is it easy to write a macro that will fill a specific input cell with 0, 1, 2, 3, etc until the output cell becomes 0 (various formulas connect these two cells) Thanks!

Can anyone give me the VBA to extract a time from a string, it'd always appear in the format ##:## but not always in the same place otherwise I'd have just used split to extract it. I did consider using split with a colon separator and then just joining 2 digits from left and right of the two...

Hello, i have a easy question. Atleast I hope it is easy. I am trying to count every cell in column b that has text in it or is not blank. Either one will work I think. Thank you so much for any help!!

Hello. I am wondering if there is a VBA i can do to format all of the date in a cell to be the same. This is for multiple row with different dates and not as easy to update. Example <tbody> <tbody> 9/20/2017 5/10/18 </tbody> what I want <tbody> 09/20/2017 05/10/2018 </tbody> </tbody>

Hi all, I request you people to help in making an excel sheet where when I enter the product daily production (product wise and code wise). When there is an order for the product , if I just enter the quantity for each product, excel should get me a code wise break down and the balance should be...