urgent

Hello I'm looking to count how many times the word "forced release" appears when associated with a certain name within a date range. Name range is in column "A" Date range is in column "B" The Status name is in column "D" The date range i want to set is in column M1 and N1 please help...

Hi, i have a data set I.e. a1 50 XX a2 62 XXX a3 6 a4 67 a5 69 a6 68 a7 84 a8 51 using VBA, i am wanting to take the Max value of Range(a1:a4) insert the value into XX then take the next set of 4 cells [Range(a5:a8)] and insert the value into XXX. this sequence needs looping till the end...

Hi There, I am looking for a dashboard which can be modified as per the analytical needs and also can be utilized for various types of data sets. Can anyone help in the same. Regards, Darpan Sharma

Hi I have a table with multiple columns and I want to calculate the number of SKUs using their codes without counting the duplicates with the condition of this sku being small griller, regular sku and in june my table looks like this month sku code sku type family 2 jan 1234...

I want to find the sum of top 3 values from several datas..But if my datasheet is not complete(that means i have less than two datas) and I want to get sum of the two datas..How can I do that?(if I put 0 on the blank cells,it works.But I dont want to put 0,I need to solve it by having the blank...

Hi guys, I'm creating a spreadsheet for remuneration and there are three ranges: 0 - 20,000 20, 001 - 40, 000 40, 001 - They each have a percentage attached to them: 0 - 20,000 = 40% 20, 001 - 40, 000 = 45% 40, 001 - = 50% What formula would I input so that when I get a number i.e. 25,000...

Hello I'm having a small problem which I just can't solve as I'm a very beginner in Excel VBA. I've been searching for different examples since last week but it doesn't really works. It's quite important for me so I'd really appreciate if someone could help me. I'd like to make a chart from a...

Hi all, This is my fist post. I am currently doing some work which is with a large database of products and I am stuck! Below is a screenshot of the sheet. How do I go about this problem? Urgent help would be appreciated! Thanks in advance <tbody> Current: abc1;abc2;abc3 random text 1...

Hi, I have been trying to create a formula where cell letter for example A1 increases next time to D1. For example; A1 on MAIN sheet is january-2015, and A7 on REFERENCE SHEET is also January -2015. However next time on MAIN Sheet February - 2015 is in D1, and REFERENCE Sheet its in B7...

Hey guys, I hope someone here is kind enough to help me with my problem... I am kinda lost and I tried everything. I have to solve to do some data adjustments and I already think about it for a long time but I am just not good enough in the excel world. This is the exercise: "To analyze the...

<colgroup><col span="5"></colgroup><tbody> Hi, I'm starting to work in a project and I know a little of BA, but I really need to do this macro in order to save hours of work a week. So I'm really thankful if someone can help me. I have to analyze some data from the prices of food. Week to week...

Anyone help me combine multiple workbook containing worksheet name "SUMMARY" into a single worksheet. Please see the link below to understand more what I am saying here. Thank you in advance. For GENERAL SUMMARY(EXPECTED) -Zee

Take 102201631000-102201633999-234245 from text file and take right formula from first two numbers =right(text1,6) & right(text2,6). i.e. 631000 & 633999 then i need to place them in text like. 102201631000 234245 102201631001 234245 102201631002 234245 102201631003 234245 till 102201633999...

Hi, Thanks in advance for your help. I have: <colgroup><col style="width:48pt" span="5" width="64"> </colgroup><tbody> Alan Maria Lisa Tony Fred GB65 GB65 GB65 GB65 GB65 GB65 GB65 GB61 GBA4 GB61 GB65 GBA4...

anyone can help me to solve this code? it always stuck "Else Without If". for my homework :( this is the code (some code like MsgBox using indonesian language because i'm from indonesia :D ): Private Sub CmbInput_Click() Set info = Worksheets(CekHarga) If info.Range("C3").Value = "" Then pesan...

Hi guys, I'm working on a project where I have to analyse reviews, gain feedback reviews and produce charts. Let me show you some example data... <colgroup><col width="64" span="26" style="width:48pt"> </colgroup><tbody> reviews Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13...

Hi, i am am trying to return the value of a cell if another cell equals text for example in cell a1, if cell b1 = 'yes' then return the data in cell c1 into cell a1 if that makes sense? thanks in advance

Hi, I am in desperate need. I have a file which looks similar to the data below: <tbody> A B C D E 20140930 3344 XYZ 141 AAB7 20140430 3344 XYZ 141 AAB7 20140930 3344 XYZ 2196 AAB7 20140430 3344 XYZ 2196 AAB7 20140930 3344 XYZ 21345 T2FG 20140430 3344 XYZ 21345 N8J5 20140930...

Hi, I am in desperate need. I have a file which looks similar to the data below: <tbody> A B C D E 20140930 3344 XYZ 141 AAB7 20140430 3344 XYZ 141 AAB7 20140930 3344 XYZ 2196 AAB7 20140430 3344 XYZ 2196 AAB7 20140930 3344 XYZ 21345 T2FG 20140430 3344 XYZ 21345 N8J5 20140930...

I have a pivot table which shows tasks for a project and I have a column beside (not a part of the pivot table) that the user enters how much complete they are. My manager has changed the format of the pivot table and has screwed up all the tasks. Is there a way with VBA to fix the re-position...