xxx

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...

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...

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...

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...

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...

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...

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...

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...

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"...

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...

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!

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...

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...

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...

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...

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...

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...

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...

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...

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>