easy

Hello, like i said probably an easy thing to do but im not able to search properly for what I want to do, basically I would like to take a current total, and add to it when another cell total changes, except i already am seeing errors in what i want to do. So i think i want a macro so after all...

Hi there! I want to loop through an array looking for the below values. IF it finds them, I want to change the value, if it doesn't, just move on. <colgroup><col></colgroup><tbody> 10 Very Easy 10 Demonstrated Well 10 Very Satisfied 1 Not Demonstrated 1 Not Satisfied 1 Not Easy...

Hi I am trying to find the best and easiest way to calculate age. I thought it is something easy but it turn it is a bit complex. The websites below showing how to calculate age. But I only found Excel-Easy.com is better and easier yet it is not that easy because they use a function called...

This should be a really easy question for you VBA experts. I have the following code: Range(Selection, Selection.End(xlUp)).Select What I would like to do is have one line code that does the above but then keep the selection but one cell below the full range. For example, if the code above...

Hi!! I have a bunch of cells which contain data similar to "0.120 (3.048)". I want to delete everything out side the brackets. Is there an easy way to do this? Thanks in advance

I am not sure if it because it is Monday, but I am having trouble with a formula that I thought would be pretty easy. Here is a simplified version of what I am trying to accomplish: I have two columns (A1:B5) and a special cell A10 (ifgreater than 0). Column A is filled in manually with %...

I'm hoping someone can help me. I have a 100 inputs and 100 outputs I populate column A with inputs and column B with outputs. Column C will contain data that will match to one cell in column A I want Column D to populate with the corresponding output from Column B. Is there an easy way to...

Hi there, I am trying to export data from a website example: https://www.flashscore.com/baseball/usa/mlb/ When I do, the data pasted from excel is shown vertically and not horizontally as on the website. Is there an easy alternative to get this data from the website to excel in a similar...

Hello, I use this line in my code to printout copies of sheet3, I need it to print 2 copies, not just 1? any help would be greatly appreciated. I am sure it is very easy change to this line, but I cant get it to work. Sheet3.Range("A1:I20").PrintOut Next Next End With

Hi there, Maybe this is an easy task for you guys, but I've been struggling with it. Basically, I need to converter the table 1 into the table 2. Thank you for any help! <colgroup><col style="mso-width-source:userset;mso-width-alt:3868;width:82pt" width="109"> <col style="width:48pt"...

Dear all, I would need a formula which gives the highest simultaneous occurence. In this simplyfied example it would 2 for "A" and 1 for "B" Seems easy but I don't grasp it. Thanks very much ... Arjen <colgroup><col width="64" style="width: 48pt;"> <col width="72" style="width: 54pt...

Here's an easy one (for those of you who are not ME, that is)... I have a multi-tab workbook that includes a MASTER sheet as well as (usually) a sheet named "UNKNOWN". My code copies some data from MASTER to UNKNOWN...BUT...what happens if "UNKNOWN" isn't there? I'm sure it will crash because...

Okay excel genius', I'm stuck in a rut and need your help! I work at a shop that carries a stock of liquids. It is my job to keep track of the inventory on a daily basis. If this was my only job, then it would be easy, but its not. So, I began working on an Excel file that could automate the...

Hi All, I'm calculating the number of days between 2 dates which is really easy, however some of the cells don't have dates in them and I'd like it to return something other than value, maybe "N/A" so we know it's been seen to. Currently it's just "AS2-AC2" Is there an easy way to do the...

Was wondering if anyone could help me out with an Rating Percentage Index (RPI) tool. There used to be one at https://techgraphs.fangraphs.com/an-rpi-spreadsheet-for-you-yes-you/ but it seems it has been taken down. I am trying to calculate RPI for a sports project I am working on and the WP...

I'm sure this is easy for somebody.. How do I multiply two numbers rounded up to the next whole number... =(A1*B1) Cell values: 20.5 x 30.25 = 620.125 ...not like this<not like="" this<not="" this="" (="A1*B1)=" 620.125 but lke this... 20.5 x 30.25 (21 x 31) = 651 651 is the answer I'm...

I'm new to Macros and working with a training tutorial, and there's a really simple problem, I just cannot figure out. I feel so stupid asking but i need help. Here's my code. So... I copied and pasted the line currently ' - which works fine But when I type the line, I get an "Unable to get...

Is there an easy way to delete all the records in a table? I don't want to delete the table, just the records. Thanks

I have a workbook with 52 tabs all identical in layout Example I am trying to create a formula that will look at cell D2 in each tab (except the one i am in) and count if the cell = 'x' is it is easy to do this or do I need to create a megaformula

Could anyone please tell me what I am doing wrong? =IF(AND(C2=C1,D2="LIS",D1="LIS")*OR(C2=C1,D2="LIP",D1="LIP")*NOT(F1="PL")*NOT(F2="PL"),TEXT(B2,"00\:00\:00")-TEXT(B1,"00\:00\:00"))*1440 I've tried doing it this way aswell...