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...
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,
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. 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 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
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...
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...
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...
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,
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