根据条件将值从一行复制到另一行 [英] Copy a Value from a row to another row based on a condition

问题描述

朋友，我需要一个正式的excel，在过去几天为这样的形式奋斗：（

 它应该搜索在B row
中以01开始的值，并且在A1，A2，A3，A4 .......中的值超过B row$中的另一个值b $ b星星与'01'
  

• 在我的表 B1 将以 01开始为100％

如果 B1 如果 B27 的值为$ code> 01 ，此正式应将 B1 值从 A1 复制到 A26

从 A27 它应该超过 B27的值（从 A27 到B行中的其他单元格，以 01开头）

解决方案

你的英文可能更好^^;

很好，在我看来，一个简单的 IF（）将适合你。

在 A2 中，放：

  = IF（LEFT（B2,2）=01，B2，A1）
  

code> A1 ，只需将值 B1 自己，因为公式不能引用单元格 A0 。

然后只需拖动公式。

Friends i need a excel formal, struggling for some thing like this form past few days :(

it should search for the value in  which starts with `01` in `B row`
and past that value in `A1,A2,A3,A4.......` till it got another value in `B row`
which stars with `01`. 

• in my table B1 will start with 01 for 100%

so after B1 if B27 has a value starting with 01, this formal should copy the B1 value from A1 to A26

from A27 it should past the value of B27 (from A27 to some other cell in B row which starts with 01 )

解决方案

Your English could be better ^^;

Anyway, if I understand well, it seems to me that a simple IF() would suit you.

In A2, put:

=IF(LEFT(B2,2)="01",B2,A1)

In A1, just put the value of B1 yourself since the formula can't reference to cell A0.

Then just drag down the formula.

这篇关于根据条件将值从一行复制到另一行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！