good

how can i use a macro to remove duplicate lines in my text file such that the last one will remain, for instance the boy is good great thinking great thinking he lives the boy is good what's up great thinking it should now be like this he lives the boy is good what's up great thinking

hello all.. i want to lookup data with criteria below, how to use vlookup or either.. <thead> Criterias Score </thead><tbody> Good 1 Bad 2 Worst 3 Enough 4 lookup given/data Expected Result Bad 2 Good 1 etc.. </tbody> thanks in advance .sst

Hi all: I have sheet Revenue with: Column(A) = "Store_code", Column(B) = "Store_name", Column(C) = "Revenue", Column(D) = "Profit" Now I want to have macro to do that: with i = 2 to last row If Average(C2:Ci)>STDEV.P(C2:Ci) then if Ci-(Average(C2:Ci)+STDEV.P(C2:Ci))>0 then Ei.value =...

Hi all, I import GL transaction data in CSV form and the one error I can't fix in PQ is the date column (e.g. 4/30/19 which PQ won't accept as a date). That's the format out of the GL. When I do a simple Replace ("/19" to "/2019") it makes it a recognized date for most rows, but some dates...

I have a few locations, eg. AMK, AMK MRT. When i type AMK, both amk and amk mrt will appear, how do i filter to exact when i type amk, only amk will appear? this is my code Sub Advanced_Filtering() Range("A8:H1611").AdvancedFilter _ Action:=xlFilterInPlace, _...

Hi there, I was hoping someone can assist me in crafting a formula that would look at text and return the most frequent appearing text provided it meets certain criteria. Example data set: <colgroup><col><col><col></colgroup><tbody> Category Sub-category Data Breakfast Light Good...

Hi everyone. I want to get very good at VBA. I'm no rush to learn it. I think maybe in a year's time I can get very good at it. I want to know whats the best way to learn it? What are is best resource to learn it in the easiest way possible?

Hello and good day, The company I work for has asked me to do some Excel training at our cooperate headquarters, I was just wondering if anyone out there knows of some free material to speak/train to? I have been asked to do a beginning and intermediate/advance class. I was just looking for a...

Hello everyone - I'm trying to input an If statement that says if date XXX PLUS 30 days is greater than date YYY, if true say "good", if false "Not good") For example cell A1 = 12/3/18 cell B1 = 12/15/18 So if cell B1 Plus 30 days (1/15/19) is greater than cell A1.....

I'm a special needs Excel user so that Title is a good as I could get for a description. But I added photos to help. Basically, my job requires me to track training for pilots. However, what I would like to do is to have two spreadsheets talk to each other. The first image is a picture of...

Hello ! Though I am a brand new member, I have been an unlogged user and big fan of MrExcel for a long time. Thank you all for countless good advices and tips I found here over time... As I am unable to find an answer to my question, here I am with my first request for help ! I need to build...

Good Morning, I am trying to format cells to change color when a specific number of days have elapsed since the input date. Cell A1 =TODAY() Cell C4 - J4 = Date training completed Cells C4 - G4 needs to be Green once date is entered for initial training. When date entered is 90 past, cell...

Hello All, I found below code on the forum and modified it slightly. Sadly, I keep having issues with it. Long story short, I have a set of text values in column I. I want Excel to find the first value "Good", insert a blank row right above it, then go 4 cells to the left and label it "Above...

Hello guys, I have a matrix with some measure columns that creates some conditions. That´s the Delta_classification. Delta_classification =...

Hello...My name is Devin, and I am planning to host a dinner among friends and acquaintances at a large dining hall within the next two weeks. I am playing around with a formula that will allow me to seat people who I think MIGHT be a good match for conversations(maybe); people who I think WILL...

Hello, mates! I have a weird requirement in the job and haven't been able to figure it out by myself. I;ve been given a weekly dataset (which needs to be in columns - per business requirements), similar to the table below: <tbody> Product W1 W2 W3 W4 ... W52 Product 1 Bad Bad Good Good ...

Hi Sorry if this off topics. I am planning to buy 32 inch monitor mainly to open more excel files and see more. I have read that 32 inch monitor might not be good to display text but good for images. Do you have any experience with 32 monitor and excel? Thank you very much.

Hi, Looking to have a button within a spreadsheet that creates an email using outlook. Rather than just saying "Hello", I'd like it to say good morning up until 12:00, good afternoon until 17:00 and good evening. I'd also like to insert a signature at the bottom. Here's what I have so far...

I need to have a function to work as follows: Row B3:B11 if the letter D or B are present return Good, If neither are present then return need If I have two D's in the Cells or 2 B's in the cell I need it return Good also. The below formula works if I only have a D in the cells, but if I take...

I believe the formula I have is being accepted by Excel, its not thrown an error. However, I am not sure the format for the hours is causing me a problem. I have to report those orders whereby we hit our SLA of 2hrs and less which is green for good. Over 2hrs is red and not so good. The lady...