万佛，请教个excel问题 - 未名空间MITBBS历史存档

b*e2011-06-20 07:06

1 楼

发10个包子
Hello bruce
As you know, we were recently notified that one of your buyers filed a
chargeback with their card issuer. One of the unique benefits of using
PayPal is that we help you fight unwarranted chargebacks and attempt to
recover your funds.
Usually the funds associated with a chargeback are temporarily held until
the card issuer makes its decision.
Because you followed the guidelines of the seller protection policy,
though, PayPal will cover the amount of the chargeback.

l*f2011-06-20 07:06

2 楼

国际转国际
国际转国内
谢谢

r*m2011-06-20 07:06

3 楼

俺有好多。

v*a2011-06-20 07:06

4 楼

N(WEEKDAY(ROW(INDIRECT(一片单元格))))
WEEKDAY(N(ROW(INDIRECT(一片单元格))))
一片单元格里都是日期 yyyy-mm-dd格式
为啥返回的值不一样？？？

D*92011-06-20 07:06

5 楼

DSB?

h*s2011-06-20 07:06

6 楼

不包。用钱买和用里程换的都不包。
UA任何票都不管住宿。除非航班狠狠的延误这种。

v*a2011-06-20 07:06

7 楼

佛门，就卡在这里了
VBA中

【在 v***a 的大作中提到】

: N(WEEKDAY(ROW(INDIRECT(一片单元格))))
: WEEKDAY(N(ROW(INDIRECT(一片单元格))))
: 一片单元格里都是日期 yyyy-mm-dd格式
: 为啥返回的值不一样？？？

b*p2011-06-20 07:06

8 楼

re

l*f2011-06-20 07:06

9 楼

谢谢
上次第二段航班取消了是包的

n*f2011-06-20 07:06

10 楼

怎么会不一样呢？你reference的是同一个格子吗？
不过我实在看不懂你想干啥？你用ROW之后跟单元格里是什么毫无关系啊？？

【在 v***a 的大作中提到】

: N(WEEKDAY(ROW(INDIRECT(一片单元格))))
: WEEKDAY(N(ROW(INDIRECT(一片单元格))))
: 一片单元格里都是日期 yyyy-mm-dd格式
: 为啥返回的值不一样？？？

y*r2011-06-20 07:06

11 楼

re

d*r2011-06-20 07:06

12 楼

取消了包的

v*a2011-06-20 07:06

13 楼

同一片区域
ROW得到的是一个array啊

【在 n*f 的大作中提到】

: 怎么会不一样呢？你reference的是同一个格子吗？
: 不过我实在看不懂你想干啥？你用ROW之后跟单元格里是什么毫无关系啊？？

j*e2011-06-20 07:06

14 楼

re

d*h2011-06-20 07:06

15 楼

包你睡机场大厅

【在 l******f 的大作中提到】

: 国际转国际
: 国际转国内
: 谢谢

n*f2011-06-20 07:06

16 楼

啊？ROW不是return row number吗？一片区域应该return 第一排的row number

【在 v***a 的大作中提到】

: 同一片区域
: ROW得到的是一个array啊

l*a2011-06-20 07:06

17 楼

re

【在 b***e 的大作中提到】

: 发10个包子
: Hello bruce
: As you know, we were recently notified that one of your buyers filed a
: chargeback with their card issuer. One of the unique benefits of using
: PayPal is that we help you fight unwarranted chargebacks and attempt to
: recover your funds.
: Usually the funds associated with a chargeback are temporarily held until
: the card issuer makes its decision.
: Because you followed the guidelines of the seller protection policy,
: though, PayPal will cover the amount of the chargeback.

G*12011-06-20 07:06

18 楼

你转换的是Row代表的Weekday,而非单元内的日期代表的Weekday

m*o2011-06-20 07:06

19 楼

re

发10个包子
Hello bruce
As you know, we were recently notified that one of your buyers filed a
chargeback with their card issuer. One of the unique benefits of using
PayPal is that we help you fight unwarranted chargebacks and attempt to
recover your funds.
Usually the funds associated with a chargeback are temporarily held until
the card issuer makes its decision.
Because you followed the guidelines of the seller protection policy,
though, PayPal will cover the amount of the chargeback.

【在 b***e 的大作中提到】

: 发10个包子
: Hello bruce
: As you know, we were recently notified that one of your buyers filed a
: chargeback with their card issuer. One of the unique benefits of using
: PayPal is that we help you fight unwarranted chargebacks and attempt to
: recover your funds.
: Usually the funds associated with a chargeback are temporarily held until
: the card issuer makes its decision.
: Because you followed the guidelines of the seller protection policy,
: though, PayPal will cover the amount of the chargeback.

G*12011-06-20 07:06

20 楼

To solve the problem, just delete the Row() function

y*m2011-06-20 07:06

21 楼

re

v*a2011-06-20 07:06

22 楼

原码是这样的
SUMPRODUCT(N(WEEKDAY(ROW(INDIRECT($D2&":"&$N2)))=2))
D2 N2是两个日期
我的理解是N和Weekday的位置应该互换
但结果不一样

【在 G****1 的大作中提到】

: To solve the problem, just delete the Row() function

d*g2011-06-20 07:06

23 楼

re

【在 y*m 的大作中提到】

: re

G*12011-06-20 07:06

24 楼

N() 的作用是强制数值类型转换，从而使得SUMPRODUCT()可以运算
和Weekday的位置不能互换

【在 v***a 的大作中提到】

: 原码是这样的
: SUMPRODUCT(N(WEEKDAY(ROW(INDIRECT($D2&":"&$N2)))=2))
: D2 N2是两个日期
: 我的理解是N和Weekday的位置应该互换
: 但结果不一样

s*r2011-06-20 07:06

25 楼

re

【在 b***e 的大作中提到】

: 发10个包子
: Hello bruce
: As you know, we were recently notified that one of your buyers filed a
: chargeback with their card issuer. One of the unique benefits of using
: PayPal is that we help you fight unwarranted chargebacks and attempt to
: recover your funds.
: Usually the funds associated with a chargeback are temporarily held until
: the card issuer makes its decision.
: Because you followed the guidelines of the seller protection policy,
: though, PayPal will cover the amount of the chargeback.

v*a2011-06-20 07:06

26 楼

问题是Weekday返回的已经是一个非日期的数而不是数组了
要这个N在那里干什么用？

【在 G****1 的大作中提到】

: N() 的作用是强制数值类型转换，从而使得SUMPRODUCT()可以运算
: 和Weekday的位置不能互换

c*t2011-06-20 07:06

27 楼

re

【在 b***e 的大作中提到】

: 发10个包子
: Hello bruce
: As you know, we were recently notified that one of your buyers filed a
: chargeback with their card issuer. One of the unique benefits of using
: PayPal is that we help you fight unwarranted chargebacks and attempt to
: recover your funds.
: Usually the funds associated with a chargeback are temporarily held until
: the card issuer makes its decision.
: Because you followed the guidelines of the seller protection policy,
: though, PayPal will cover the amount of the chargeback.

G*12011-06-20 07:06

28 楼

Weekday返回后有一个逻辑判断（？=2），其结果是true/false

【在 v***a 的大作中提到】

: 问题是Weekday返回的已经是一个非日期的数而不是数组了
: 要这个N在那里干什么用？

w*72011-06-20 07:06

29 楼

re

【在 b***e 的大作中提到】

: 发10个包子
: Hello bruce
: As you know, we were recently notified that one of your buyers filed a
: chargeback with their card issuer. One of the unique benefits of using
: PayPal is that we help you fight unwarranted chargebacks and attempt to
: recover your funds.
: Usually the funds associated with a chargeback are temporarily held until
: the card issuer makes its decision.
: Because you followed the guidelines of the seller protection policy,
: though, PayPal will cover the amount of the chargeback.

v*a2011-06-20 07:06

30 楼

你是说这里专门用N吧true/false转成1/0?
excel这么傻？

【在 G****1 的大作中提到】

: Weekday返回后有一个逻辑判断（？=2），其结果是true/false

b*g2011-06-20 07:06

31 楼

re

until

【在 b***e 的大作中提到】

: 发10个包子
: Hello bruce
: As you know, we were recently notified that one of your buyers filed a
: chargeback with their card issuer. One of the unique benefits of using
: PayPal is that we help you fight unwarranted chargebacks and attempt to
: recover your funds.
: Usually the funds associated with a chargeback are temporarily held until
: the card issuer makes its decision.
: Because you followed the guidelines of the seller protection policy,
: though, PayPal will cover the amount of the chargeback.

n*f2011-06-20 07:06

32 楼

你sumproduct的不是weekday，而是weekday=2的逻辑判断，return的是一列true／
false，N是把T／F转成1跟0，不然的话sumproduct会出#value
不过还是不懂ROW在干啥

【在 v***a 的大作中提到】

: 问题是Weekday返回的已经是一个非日期的数而不是数组了
: 要这个N在那里干什么用？

b*o2011-06-20 07:06

33 楼

re。。。

G*12011-06-20 07:06

34 楼

SUMPRODUCT() 只能运算数值，so it can't take true/false as parameters
对这个SUMPRODUCT()在此的作用不是很理解

【在 v***a 的大作中提到】

: 你是说这里专门用N吧true/false转成1/0?
: excel这么傻？

d*12011-06-20 07:06

35 楼

热

v*a2011-06-20 07:06

36 楼

他用sumproduct来数数就是
if weekday=2
count++

【在 G****1 的大作中提到】

: SUMPRODUCT() 只能运算数值，so it can't take true/false as parameters
: 对这个SUMPRODUCT()在此的作用不是很理解

W*t2011-06-20 07:06

37 楼

re

n*f2011-06-20 07:06

38 楼

sumproduct是很管用的，唯一麻烦的是不能自动转换非数值，但你可以在sumproduct里
面作运算，比如用
SUMPRODUCT（1*（WEEKDAY＝2））可以达到相同的效果，因为做乘法的时候excel是会
自动把true，false转成数值的
功能上基本可以取代SUMIFS

【在 v***a 的大作中提到】

: 他用sumproduct来数数就是
: if weekday=2
: count++

c*02011-06-20 07:06

39 楼

re

z*32011-06-20 07:06

40 楼

DSB

z*02011-06-20 07:06

41 楼

RE

a*l2011-06-20 07:06

42 楼

RE!
CONG

a*92011-06-20 07:06

43 楼

re

AE2011-06-20 07:06

44 楼

re

发10个包子
Hello bruce
As you know, we were recently notified that one of your buyers filed a
chargeback with their card issuer. One of the unique benefits of using
PayPal is that we help you fight unwarranted chargebacks and attempt to
recover your funds.
Usually the funds associated with a chargeback are temporarily held until
the card issuer makes its decision.
Because you followed the guidelines of the seller protection policy,
though, PayPal will cover the amount of the chargeback.

【在 b***e 的大作中提到】

: 发10个包子
: Hello bruce
: As you know, we were recently notified that one of your buyers filed a
: chargeback with their card issuer. One of the unique benefits of using
: PayPal is that we help you fight unwarranted chargebacks and attempt to
: recover your funds.
: Usually the funds associated with a chargeback are temporarily held until
: the card issuer makes its decision.
: Because you followed the guidelines of the seller protection policy,
: though, PayPal will cover the amount of the chargeback.

d*e2011-06-20 07:06

45 楼

re

d*e2011-06-20 07:06

46 楼

re

n*s2011-06-20 07:06

47 楼

hot

b*n2011-06-20 07:06

48 楼

re

【在 b***e 的大作中提到】

: 发10个包子
: Hello bruce
: As you know, we were recently notified that one of your buyers filed a
: chargeback with their card issuer. One of the unique benefits of using
: PayPal is that we help you fight unwarranted chargebacks and attempt to
: recover your funds.
: Usually the funds associated with a chargeback are temporarily held until
: the card issuer makes its decision.
: Because you followed the guidelines of the seller protection policy,
: though, PayPal will cover the amount of the chargeback.

E*r2011-06-20 07:06

49 楼

re

【在 b***e 的大作中提到】

: 发10个包子
: Hello bruce
: As you know, we were recently notified that one of your buyers filed a
: chargeback with their card issuer. One of the unique benefits of using
: PayPal is that we help you fight unwarranted chargebacks and attempt to
: recover your funds.
: Usually the funds associated with a chargeback are temporarily held until
: the card issuer makes its decision.
: Because you followed the guidelines of the seller protection policy,
: though, PayPal will cover the amount of the chargeback.

d*e2011-06-20 07:06

50 楼

cong!

【在 b***e 的大作中提到】

: 发10个包子
: Hello bruce
: As you know, we were recently notified that one of your buyers filed a
: chargeback with their card issuer. One of the unique benefits of using
: PayPal is that we help you fight unwarranted chargebacks and attempt to
: recover your funds.
: Usually the funds associated with a chargeback are temporarily held until
: the card issuer makes its decision.
: Because you followed the guidelines of the seller protection policy,
: though, PayPal will cover the amount of the chargeback.

s*j2011-06-20 07:06

51 楼

re

R*y2011-06-20 07:06

52 楼

re

y*72011-06-20 07:06

53 楼

CHI XIEXIE

【在 b***e 的大作中提到】

: 发10个包子
: Hello bruce
: As you know, we were recently notified that one of your buyers filed a
: chargeback with their card issuer. One of the unique benefits of using
: PayPal is that we help you fight unwarranted chargebacks and attempt to
: recover your funds.
: Usually the funds associated with a chargeback are temporarily held until
: the card issuer makes its decision.
: Because you followed the guidelines of the seller protection policy,
: though, PayPal will cover the amount of the chargeback.

O*e2011-06-20 07:06

54 楼

re

g*92011-06-20 07:06

55 楼

真好，恭喜恭喜

a*e2011-06-20 07:06

56 楼

cong