xxx

  1. M

    Count the number of Xs in a cell

    Hello All, I need a formula that will allow me to count the number of Xs in a cell....The total Xs should be 5, but when I use the formula, COUNTA(B2:M2) , it counts 3.... I tried COUNTIF(B2:M2,"X") but it also counted only 3.... What formula can I use to count the number of Xs in each cell...
  2. B

    Can't use Excel - "There was a problem connecting to the server" error.

    I'm away from my office traveling, and trying to get some work done. Unfortunately, every time I open Excel I immediately get an error box that pops up saying, "There was a problem connecting to the server xxx," with xxx being the name of a server I sometimes connect to when I'm in the office to...
  3. V

    If Elseif else statement

    How to write a VBA code to get the below output. Thanks If Column A = AAA , Column C = XXX , Column E = YYY Then column F = Yes If Column A = BBB , Column C = XXX , Column E = YYY Then column F = Yes If Column A = ZZZ , Column C = XXX , Column E = YYY Then column F = Yes and if Column A is...
  4. H

    VBA: If Range Contains Cell Value Copy than del

    I need help :) If Col C cell contain 'Poster' OR 'Index' COPY TO Col E Cell to Col A Cell Than Delete Col E E the flow is *xxx refer to some text If Col C cell contain 'Poster' OR 'Index' <tbody> A B C D E xxx xxx Poster 13 62131 xxx xxx Index 16 62141 </tbody> COPY TO Col E Cell...
  5. L

    VBA Autofilter second criteria not working

    Hello all, I have quick question. I am struggling with autofilter in vba. I have following code: itm is shift code, which can be xxx, aaa, bbb, ccc etc... FilterArr = Array("*" & Itm, "*" & Itm & "/*") FilterRng.AutoFilter field:=1, Criteria1:=FilterArr, Operator:=xlFilterValues...
  6. P

    How to get a specific text beside another text

    Hi. I hope someone can help me. 1. I need to get the specific amount next to the word Principal For example: A1: bla bla bla xxx xxxx blabla bla bla bla blaPrincipal:1,000 xxx bla bla xxxx xxxx xxxxx bla bla bla 11/14/2017538.95Interest and bla bla bla Basically, all of the data are pasted...
  7. megera716

    Did customer in one list buy an item in another list?

    Customer produces and sells widgets (CW). We sell a report about the performance of the widgets. I have a spreadsheet of customers with one report sale per row - Customer Name in Column A, Product Name in Column B, other data (irrelevant to my question) in other columns. Customer may have...
  8. S

    Aging Report Formula?

    I was wondering if anyone knew if this was possible, I am trying to age a large file of accounts (5000+) that simply have user ID's attached to them, amounts and their date. What I am trying to do is to allocate each age appropriately. Meaning I would like to subtotal per User Id the fact that...
  9. R

    Lookup "Next" function in VBA

    Hey All, I'm trying to make something to help my team. I'm using a vlookup function and it's working great like it always does BUT some values I use to lookup have multiple results (i.e. 2 or 3.) 90% of my values are unique. I'm looking for a way to either have a VBA button that says "Next"...
  10. R

    MsgBox if Range as date has passed

    I am sure this has been answered before, therefore I apologize in advance. Can someone please assist me in a macro code under Worksheet_calculate to simply write. If Range("N9") < Now() And Range("O9").value = False then MsgBox "xxx xxx" End If It seems simple yet I can not come up with it...
  11. 2

    Split specific text

    Hi, i have several rows that contains some text "xxxxxxxxxxxxxxxx (xxx)" all of them has ()at the end. i wonder how can i cut (xxx) data to new column. Thanks!
  12. R

    MsgBox if Range as date has passed

    I am sure this has been answered before, therefore I apologize in advance. Can someone please assist me in a macro code under Worksheet_calculate to simply write. If Range("N9") < Now() And Range("O9").value = False then MsgBox "xxx xxx" End If It seems simple yet I can not come up with it...
  13. K

    Hlookup, offset, sum

    Hello all! It's my first post, so please be nice :-) I'm trying to create a "dashboard" which looks up a value (hlookup) in the top row of the data set and returns back a sum of its "scores" from the column to the right. I tried and failed at nesting hlookup, sumproduct, and wrapping them in an...
  14. K

    Combining transactions

    Good evening, There are occasions when I am presented with line level detail and need to sum related lines into a single transaction. At the moment I sort and subtotal related lines and copy detail from the cells above into subtotal lines. This be as follows: Date Unique Reference Line...
  15. K

    Insert lines and fill via VBA macro

    Hi there I am hoping for your help in creating a macro that will automate a repetitive piece of work I am doing I have a sheet with data in column A and B, both having headers. Column A contains a name and be B has a reference to an account. Some have references to multiple accounts and are...
  16. S

    VBA Filter

    Hi, i need some help on two matters. both are related to filters, involving dates and multiple column. a sample of my database as such: <tbody> Name Project Gender Type Funding Topic Date of Application Survey Date 1 Survey Date 2 Survey Date 3 Survey Date 4 Survey Date 5...
  17. N

    Copy cell value based on another cell value criteria

    Hi, could anybody help me please with VBA code to copy value based on another cell value. I have a table where I put data in the column "E". If the value in the cell "EZ" is the same as value in the "B1" I need to copy value from "C1" to "FZ". I need to run the code anytime when the value is...
  18. A

    Get the contents of column A and put it in Column B overwiting a tag

    I am working with just 2 columns. I am writing a macro to get the value from column A and put it in column B, overwriting the tag style, so that row 1 appears like the following: The Regency Straight Back is a traditional ....., and do this for all rows Column A...
  19. I

    vlookup help

    Hi is it possible to use vlookup to extract data on the row below a reference? A B C D 1 Donna xxx xxx xxx 2 xxx 3 Vicky xxx xxx xxx 4 xxx So if I do a vlookup formula for Vicky and want to...
  20. C

    Simple IF statement? Maybe not. Help!!

    I need a formula that will satisfy this logic statement: If D2 = 1, subtract B3 from B2 and multiply the results by 1440. If D2 does not = 1, enter XXX. The answer goes in E2. <tbody> A B C D E 1 DATE TIME GUARD BUILDING TIME 2 07/02/18 6:28:00 321 1 3 07/02/18 7:35:00 333 </tbody>

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top