## ActiveCell.Formula Help

I am trying to write a piece of code that ultimately will display a formula in a cell of two cell locations. The below code simply pastes the value in the cell …

I am trying to write a piece of code that ultimately will display a formula in a cell of two cell locations. The below code simply pastes the value in the cell …

0down votefavorite I need to know how to take data (in Excel 2016) in one column (with many rows) and split it into 7 columns, keeping the order …

Hi, I want to use formula for TIME calculations. For Example I have the data of in punch and out punch and I want to calculate who came after 9:30am and …

Ok newbie here,very little excel knowlegde so be gentle! I have 5 lists (say A1, B2, C3, D4, E5)- names,address etc. They are members of a club who will be …

Dear All, I’m pretty new to Excel and appreciate any guidance regarding the following issue that I encounter; In the following, I have a row (in …

Hello, My code works for maximum of 1000 rows but my database consist of 57,000 rows. As a result it doesnt run and gets hang. Could you please help me? Sub …

hi i am not a pro in using excel.i have a problem with my chart i have a chart like this: a | hello b …

i have 5,4,6,9,10 values in c4. i need to fill the consequent cells with ‘x’ according to the number in c1.i.e when the value is ‘x’ …

I am creating an excel document to help make work easier; I work at a non-profit agency. We have multiple families we serve (over 50). For each family, we must …

Are there any limitations as to the number of sheets, the drive where the target workbook is located or the number of caracters of the target workbook? Im …

I have two very larges sheets (45,000 Row, BL colloums each). Each sheet has the same columns in the same order but the row data is not necessairly in the same …

Hii, i want to autosum of two numbers as below 1+1 in one cel and 2+3 in another cel. i want a answer in third cel is 7 (i.e. 1+1=2 & 2+3=5 total 7 By: …

Hello, I am trying to find an answer to this problem. I can see that there are answers to this on Google but I’m still finding it hard to …

Please see below table No. of beneficiaries Actual Diet Total Poshahar Days No of AWCs where Poshahar distributed 15 16 17 18 2263 40382 1320 74 8929 …

Is there a simpler way to achieve =((Attendance!$C$3*Attendance!C5))+ …

how do I use if function to see if an appointment can be made at a specific date and time. So basically If I have a sheet of previously made appointments and I …

Comparing 2 collumns from 2 different groups having a empty collumn between the groups , each group containing 4 collumns, inserting the cell in every collumn …

if I want to highlight the cell value if it is lesser than 10:00:00 and greater than 11:00:00. By:

Hi , I have made the connection of SQL and Excel and able to execute one query by goin in properties in Data connectiion. What i need to know Can i run …

Hi. I want to see the results in a pop up when click on a cell. For a example when clicking on a product to calculate the discounts of a certain customer and …

Hi, I’m a beginnger in using Excel 2013 here but i do know how to use the basic functions ie. (SUM, ROUNDUP etc…) Is it possible to have a function …

Hello everybody I have the following problem:I want to find the rowvalue of the smallest number in a column, however if there is a zero in the column next to …

ABIS was founded in Shenzhen China,in 1996,adjacent to Hong Kong,has its own factory of 12,000 square meters. With the advanced facilities from Germany, Swiss …

Utterly baffled here: I have an Exel VBA macro that works fine unless I am on a particular laptop as follows: If I open the program on my ROG laptop and run …

Hi, I have an excel file with more than 100 sheets with same format. I would like to copy current month numbers (range of sells) of selected sheets …

Hello. I have the following table. I would need the excel to pop up a message where only 1 cathegory is shown when it is in the range.f.e. “Your table …

lets say i have : start date 1 and end date 1 , start date 2 and end date 2 , start date 3 and end date 3. I want to know how many times the date …

Hi, this is my first question here. So, what I’m trying to make is, a single cell (lets say A1) that can goes blank everytime i put value and press …

Hi Trying to get my countif formula to work when I filter certain cells. At the moment the countif is counting the entire spreadsheet against a criteria …

Hi Trying to get my countif formula to work when I filter certain cells. At the moment the countif is counting the entire spreadsheet against a criteria …

Hello, I need help with a formula that will make this happen: If the number in cell G4 is between 80%-100%, then cell I5 will say “Regular.” …

Плёнка играет роль пароизоляции (бетон может впитывать воду и отдавать в предстоящем), …

I want to averaged 10 numbers in a row by specifying the bottom cell location from another cell where I have generated a cell cell location with =Address(count …

This is my data set, I am trying to create a rule that will highlight unique values STATEMENT 1 STATEMENT 2 E 23.73 D 582.7 A 413.47 A 413.47 B …

20-Jul-17 Elution Pass NA 20-Jul-17 Elution Pass NA 21-Jul-17 Failure Fault 21-Jul-17 Failure Fault 21-Jul-17 Elution Pass NA 21-Jul-17 Failure …

Hello. (using word and excel 2010) I am working off of microsoft word and right now, my code is used to: 1) Separate mail merged pages, remove the …

in one sheet no. is 77031ym05j and in another sheet no. is 77031ym05 (is correct ) so what is the to get 77031ym05 in front of 77031ym05j.. like …

I have a matrix I am working on. The matrix ranges from 0000-2330 Monday-Sunday (Columns P-V,4-49). I need a formula to get a +1 count for each person working …

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. How Google uses data when you use our partners' sites or apps

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.