Search results

Dears, thanks a lot for your very useful replies, you let me get that clearly. Gratefully

Hello there, please I ask for how can I concatenate multiple Cells listed vertically into One cell split by ";" eg: Login 81287 88446 82395 81284 81296 82311 81251 82368 82363 to be 81287;88446;82395;81284;81296;82311;81251;82368;82363 thanks a lot,

we can get it closer by overlooking some conditions if it would help. | We can do that splitting for a few number of lengths per each time eg: we can set 10 sizes at most but not 50 or more || We can use One size of bars "600 cm"or "650 cm". I Supposed the variety will give us a flexibility...

Hi Narayan, It's not sample file, but this data is for One project which when I finish it, I'll take another project with differents number of windows or doors and different lengths. yes, there are some data relating to an upcoming project or an on-going project. if you need to post that...

Hello Narayan, No problem ever, I know that optimization is considerably hard to be done, I'm exactly doing it randomly, I've split my bars per window length and it causes a lot of waste of cost, I can't count the amount of wastage because of the number of projects is growing up. I'll try to...

Sorry Narayan take your full time. I'm just want to preview my interst

Is there any good news please,

@NARAYANK991 appreciate your great support, I just need to inform you that i'm interested about the sheet, but at the same time i didn't like to push you to be compressed.

Hi Narayan I uploaded a 60 item.

@Eloise T Sorry i've a problem about image uploading. But it is a snapshot for the excel sheet not more. @NARAYANK991 The posted is just an example but not real data. For what about of number of doors its according to the Customer Order may be reach to 50 or more and sometimes the number...

Hello, please I need your support in my sheet calculation, in a recap, I work in Aluminium doors installation, and I have the bars that will be split to get the Length and the width to install doors, I have 2 sizes for this bars "600 cm" and "650 cm". the question if I have 50 doors need to be...

@p45cal please I need your support for the same topic what about if I want to apply multiple SQL query, I ask how to add the below SQL Queries to the code to be run select count(outage_with_detection) from customer_age where call_date >= Start date time...

@p45cal it works fine, thanks a lot for your great support.

hello there, please I need your support in editing SQL query via VBA, i'm not familiar with SQL or VBA coding but after some serches into internet reached to have a code with SQL Connection and i set a SQL query into VBA. what i want is I have 2 static criterias used in SQL...

Hi Hui, it worked fine thanks a lot sir

Hello there, please I need your support as I have a table which needs to transpose the data vertically. I want to transpose some of columns not the all table column, but each row will be transposed at autonomous table like the data that located at "Transpose" worksheet. thanks a lot,

Hi Jindon, thanks a lot, it works perfectly. Gratefully,

Hello there, please i need help as i have some data in a table, there is a column that contain a string and might have a "comma" that split an items, i need to duplicate the column that have a comma 1st table: as shown @ column ("E"), there is a Comma that split the items. as shown at 2nd...

Dears, please i need help as i have a values column called "Call Date" need to verify if this column indexed in the array of Date columns "Time from()" and "time to" i need if the call date Value indexed between the dates array put a string "Valid" into "Validation" column gratefully

Hello Ashesh, thanks a lot for your support as your function get the result totally true, for a bout my last port it was an issue and solved thanks a lot,

Hello Asheesh, i applied your function and got a result, but i have an issue that my sheet have floating when remove that floating via "text to Columns" option the array parenthesis "{}" removes and got #VALUE!. so can i use a nested formula to apply this logic or how can i ignore these...

Hello, please i need your support in extracting Num from String as i have an array which contain a values that values be Num or string or Num concatenate String. i need to export the num records only. then repeat that extracted record till the next one

Hi vletm, the pic is a snapshot for the uploaded sheet. i need all colored cell's value to be converted to 15-"the exist value eg: if the cell have 12 i need to be (15-12)>>3, if it have 0 i need to be filled with 15 etc... i uploaded a new workbook with the result that i need to get in the...

Hello there, please i need your support in getting this issue solved as shown, i need to change the colored cell's values to be (15-the filled #) by VBA code. gratefully,

Hello Luke M, yes you are right about the problem cause, i checked the provided update from you and everything go well thank you so much for your support.