Consult the excel great god! Formula of data respectively-CodePudding

The following diagram, in the yellow cell, how to write a formula to achieve this effect? Thank you very much!

CodePudding user response:

[=CONCAT (TRIM (MID (SUBSTITUTE (A1 & amp; "/", "/", "*" & amp; REPT (99), ""), ROW ($1, $10) * 100-99-13)) & amp; TRIM (MID (SUBSTITUTE (B1,"/", "+" & amp; REPT (99), ""), ROW ($1, $10) * 100-99-13)))

CodePudding user response:

@ lanfengye: thank enthusiastic guidance!
After I copy a formula, found that the calculated out, please help to see where the problem is? Thank you very much!

reference 1st floor lanfengye response:

[=CONCAT (TRIM (MID (SUBSTITUTE (A1 & amp; "/", "/", "*" & amp; REPT (99), ""), ROW ($1, $10) * 100-99-13)) & amp; TRIM (MID (SUBSTITUTE (B1,"/", "+" & amp; REPT (99), ""), ROW ($1, $10) * 100-99-13)))

CodePudding user response:

refer to the second floor zdh932 response:

@ lanfengye: thank enthusiastic guidance!
After I copy a formula, found that the calculated out, please help to see where the problem is? Thank you very much!

Quote: refer to 1st floor lanfengye response:

[=CONCAT (TRIM (MID (SUBSTITUTE (A1 & amp; "/", "/", "*" & amp; REPT (99), ""), ROW ($1, $10) * 100-99-13)) & amp; TRIM (MID (SUBSTITUTE (B1,"/", "+" & amp; REPT (99), ""), ROW ($1, $10) * 100-99-13)))

You are WPS,,,, some function is not supported, rept to concat, these two functions you see if there are any,,,

CodePudding user response:

refer to the second floor zdh932 response:

@ lanfengye: thank enthusiastic guidance!
After I copy a formula, found that the calculated out, please help to see where the problem is? Thank you very much!

Quote: refer to 1st floor lanfengye response:

[=CONCAT (TRIM (MID (SUBSTITUTE (A1 & amp; "/", "/", "*" & amp; REPT (99), ""), ROW ($1, $10) * 100-99-13)) & amp; TRIM (MID (SUBSTITUTE (B1,"/", "+" & amp; REPT (99), ""), ROW ($1, $10) * 100-99-13)))

try once, WPS to three key... Array formula... I'm not three keys can also be in Excel

CodePudding user response:

reference 4 floor lanfengye response:

Quote: refer to the second floor zdh932 response:

@ lanfengye: thank enthusiastic guidance!
After I copy a formula, found that the calculated out, please help to see where the problem is? Thank you very much!

Quote: refer to 1st floor lanfengye response:

[=CONCAT (TRIM (MID (SUBSTITUTE (A1 & amp; "/", "/", "*" & amp; REPT (99), ""), ROW ($1, $10) * 100-99-13)) & amp; TRIM (MID (SUBSTITUTE (B1,"/", "+" & amp; REPT (99), ""), ROW ($1, $10) * 100-99-13)))

try once, WPS to three key... Array formula... I'm not Excel three keys can also

Is not the WPS, Excel, tried three key array is also not to

CodePudding user response:

reference

try once, WPS to three key... Array formula... I'm not Excel three keys can also

Is not the WPS, Excel, tried three key array is also not to

you this color is the color the WPS saw... Excel is sure? What version? Capture a bit bigger?

CodePudding user response:

Version is Excel 2013, color is the color I adjust according to the system, in order to protect the eyes, screenshots are as follows:

refer to 6th floor lanfengye response:

reference
try once, WPS to three key... Array formula... I'm not Excel three keys can also

Is not the WPS, Excel, tried three key array is also not to

you this color is the color the WPS saw... Excel is sure? What version? Capture a bit bigger?

CodePudding user response:

Excel2013 version

refer to 6th floor lanfengye response:

reference
try once, WPS to three key... Array formula... I'm not Excel three keys can also

Is not the WPS, Excel, tried three key array is also not to

you this color is the color the WPS saw... Excel is sure? What version? Capture a bit bigger?

CodePudding user response:

refer to the eighth floor zdh932 response:

Excel2013 version

Quote: refer to the sixth floor lanfengye response:

reference
try once, WPS to three key... Array formula... I'm not Excel three keys can also

nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull