excel & array

I am trying to find result of sort data in table with specific criteria for example : The picture of excel-table that i trying to figure it out yellow is ALL-JOB fill by user RED is Unfinish JOB sort by "START DATE" Green is Completed JOB sort by "END DATE" and "JOB ID" i need to sorting data...

Hi everyone, I need help on VBA code to copy and merge data from 2 pivot tables into a single data set to be display in another sheet. Below is data Sheet 1 in excel. <tbody> Pivot A Shipto Soldto LV1 LV2 LV3 001 A Local NE Manufacturer 002 B Local NE Manufacturer 003 C Global CE...

Hi, Can I please ask for help, this is the formula im using =PROPER(RIGHT(O4,LEN(O4)-SEARCH(".",O4))&" "&LEFT(O4,SEARCH(".",O4))) the result of the formula is at Name Row =PROPER(RIGHT(O4,LEN(O4)-SEARCH(".",O4))&" "&LEFT(O4,SEARCH(".",O4))) I wanted to make the name look like Abbas, Shin...

I am new to VBA and coding in general. I am trying to copy/transpose/paste a two-column PivotTable and I need it to paste vertically and break on blank rows. I need to copy each group in the PivotTable and transpose paste values vertically on a new worksheet. I cannot figure out how to...

I've done Array formula's before and got them working, but for whatever reason, it's not working on my current information. Currently I've two sheets: Master Sheet - 'Sheet1M' 2nd Sheet - 'Sheet2S' Sheet1M contains the following: <tbody> <tbody> 60521235 </tbody> PART01 <tbody>...

Hi there Could you please help me here I need to merge particular sheet "Consolidated data" from the different work book saved in the same folder to another work book without formulas. Save as values.

I am trying to export (and automate) a VBA excel file to SQL . So I tried to configure an Excel data source as a linked server But I got the following issue: Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc) ADDITIONAL INFORMATION: An exception occurred...

Hi all, I have in one column values (red, white) and in another column values (Jack, Marie David etc.) There are several hundreds of rows so that there are different names once but for each name a color (red or white) is assigned. So for example: <tbody> Sheet 1 Color Name red Jack...

Hello, I have a large population (30k+) of amounts which contribute to the total amount in another table. I was able to pull the two data-sets together, so I can see in one table the whole amount and all of the individual amounts. The issue is that for a given unique identifier (e.g., 12345)...

I am trying to create a list of unique values that relate to another list of unique values. Column A has a list of managers and column B has a list of supervisors that report to the manager in column A. There will be multiple supervisors that report to a mange, but no 1 supervisor will report...

Hi all, I need your help, if possible. Is there a formula that can rearrange the value of the text string from a cell for example: Original Value: 4079/LCG330/LC Required output: LCG330/4079 Any help is really appreciated.

I'm trying to save first column of the each sheet as a separate csv file who's name depends on name of each sheet in work book. Once i'm done saving those sheets i want to open those files one by one to align the data in them. below is my code can you please assist how can i open files from same...

Hi, I need Help please kind sir/mam. this is the formula im using to get the week-start from January 2019 to April 2019 =AE2-WEEKDAY(AE2,2)+1 From January the week-start ends on Sundays but then the following months changed to Monday How can I keep it consistent ? your help is greatly...

Hi Super-Brainers Can you help me decide what is wrong with this formula? It is giving me #value error. =SUMPRODUCT(1*($D$3:$D$354=$A4),1*(MONTH($E$3:$E$502)=$D$1)) Column D : Stages (e.g. Lead, Opportunity, Converted etc.) A4 = Lead Column E: Date corresponding to stage value from column D...

My Copy paste starts on "A122", continues running on next page, however, I tried inserting on purpose 8 additional rows for automatic insert after large data set runs from page 1 through all other pages. I need some help knowing why the last line of code does not include 8 rows down on next...

Great day, I'd like to ask for you kind assistance Will it be possible to count the VL that falls under the date today? if yes can you kindly help please thank you so much:confused: 18-Mar 19-Mar 20-Mar 21-Mar 22-Mar 23-Mar 24-Mar Schedule Region Monday...

Im trying to get the Max value from the longest wait time for the month of Jan, Feb and Mar.i tried using =max(if($c$c="Jan",$h$h)) but it wont work, can someone help me please? thank you so much. SkillGroup Year Month Day Total Inbound Calls Total Calls To Queue Total Calls Abandoned In...

I have data in even row i would like to copy data from even row and paste into odd row and loop goes to last row of sheet. <tbody> A B C 1 2 Data1 Data1 Data1 3 4 Data2 Data2 Data2 5 6 Data3 Data3 Data3 7 </tbody> <tbody> A B C 1 2 Data1 Data1 Data1 3...

I currently have a set of data as follows: <tbody> Jan-18 Feb-18 Mar-18 Apr-18 Jun-18 Jul-18 A 1 2 3 4 5 6 B 7 8 9 10 11 12 C 13 14 15 16 17 18 D 19 20 21 22 23 24 </tbody> I have a dynamic lookup value for the date and want to be able to sum the values that are less than or equal...

Hi, I have set of values in column A, for e.g. 10,20,30,40,50,60,70,80,90 and 100. Now in column B I have below values 33,50,60,90 How to identify, range of values in column A based on values in column B. It should return following values : 30,40,50,60,70,80 and 90(assuming we are taking...