Search results

Thank you so much for your help

Hello Need help on creating formula for contents. In column A is reference page follow by column B pages a list of fruits and then create excel formula in column C to print first and last range of page numbers by each different type of fruits. see example below For example there are 2 pages...

I see. Thank you.

The old column in column a is the main query. This is an example I want the output to look like in column B. Make a new column in column C. Looking for a formula to run all in one go. Hope this makes sense.

Hi peoflyer See attached.

Hi, See picture below, in column A (oldcolumn) contain mixture of numeric and characters, how to fill the blank cells like column B (NewColumn)? Thanks Mr Singh

Wow. Excellent! Many thanks Bosco_yip.

Wow. Thank you. Bosco_yip. Similiar last thing how to repeat sequence if you copy date period 5 times but adding date + 1 after 5 times? see example 01/01/1993 01/01/1993 01/01/1993 01/01/1993 01/01/1993 01/01/1994 01/01/1994 01/01/1994 01/01/1994 01/01/1994 01/01/1995 01/01/1995 01/01/1995...

How to repeat sequence if you copy each 3 year time period 5 times? see example 1993-1995 1993-1995 1993-1995 1993-1995 1993-1995 1994-1996 1994-1996 1994-1996 1994-1996 1994-1996 1995-1997 1995-1997 1995-1997 1995-1997 1995-1997 etc.. Thank you Mr Singh

Thanks bosco_yip and INCOMETAX111

Thanks INCOMETAX111. Interesting. Its work from 1993-1995 to 1995-1997 but not the next sequence. I still type long list of year period from 1993-1995 up to current one time then it works. Mr Singh

Hi How to repeat 3 years time period when you drag down the cells? Is there a quick way? 1993-1995 1994-1996 1995-1997 1996-1998 1997-1999 and so on Thanks Mr Singh

Thanks Fluff13

Hi, Need help on excel formula in column c for all the conditions in 1. IF NUMERATOR AND DENOMINATOR both 0 THEN "-1" IF (NUMERATOR = 0) AND (DENOMINATOR > 0) THEN "0" IF NUMERATOR AND DENOMINATOR both > 0 THEN CALCULATE N/D * 1000 IF (NUMERATOR > 0) AND (DENOMINATOR = 0) THEN "-1" See table...

Thanks vletm.

Hi, In cell A1 is drop down list of year period (I used from data validation) e.g. 2015/16, 2016/17, 2017/18, 2018/19, 2019/20 In cell A2 the output is single year Here are the conditions:- If A1=2015/16 then A2=2015 If A1=2016/17 then A2=2016 If A1=2017/18 then A2=2017 If A1=2018/19 then...

Thanks very much indeed. It's works!! Bw Mr Singh

Hi, I got a list of 1000 ww1 soldiers records. How to split up the text in cell A1 below into next 4 columns - (B1) Name, (C1) Corps Regiment, (D1) No and (E1) Rank? for example in cell A2 and A3 - Amar, Bedi. Corps Regiment No Rank 36th Sikhs 3687 Sepoy. Atma, Singh. Corps Regiment No Rank...

Thank you Ali. It works. Want the first formula to remove. Perfect!

Hi, need help on create excel split formula on how to get remove after the 4th underscore to the right. For example H1_1_12i_P_8-19yrs change to H1_1_12i_P H2_3_01i_P_75+ change to H2_3_01i_P H3_5_48i_M_under 20 change to H3_5_48i_M Thank you, Mr Singh

Thanks Marc L, Ali. Keen on automation using VBA or macro with Excel 365. Does anyone know script on how to split data into multiple worksheets based on key column and export to individual files in csv ? Mr Singh

Hi, How to split data into multiple worksheets based on key column and export to individual files in csv using excel 365? Thanks Mr Singh

Thanks Ashhu. That's cool. Mr Singh

Hi, I have an excel file containing 1 worksheet only. This worksheet contain table template and i want to duplicate this sheet 20 times in one go. I don't want to copy one by one using right click sheet , copy and paste. Is there a quick way of paste the same sheet 20 times or 50 times etc...

Hi, How to highlight cells with two different fill colours one is yellow mean Maximum and purple mean minimum in mutliple columns in one go? See example FIELD 1 FIELD 2 FIELD 3 FIELD 4 23 49 3.4 5 232 666 0.43 33 6 496 0.042 22 67 9 1.3 99 5 6642 45.6 77 Many thanks Mr Singh