Select Excel Language:
Select Delimiter:
| BBCode HTML Conversion in Excel.xlsx | |||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Sayfa1 | |||||||||||||||||||||
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | |
| 1 | |||||||||||||||||||||
| 2 | SIRA | ÜRÜN | ÜRÜN FİYAT | Ürün | Fiyat Toplam | Ürün | Fiyat Toplam | Ürün | Fiyat Toplam | Ürün | Fiyat Toplam | ||||||||||
| 3 | 1 | ELMA | 15,00 | ELMA | 93,00 | ELMA | 93,00 | ELMA | 93,00 | ELMA | 93,00 | ||||||||||
| 4 | 2 | ARMUT | 13,00 | ARMUT | 13,00 | ARMUT | 13,00 | ARMUT | 17,00 | ARMUT | 13,00 | ||||||||||
| 5 | 3 | KİRAZ | 17,00 | KİRAZ | 69,00 | KİRAZ | 69,00 | KİRAZ | 52,00 | KİRAZ | 69,00 | ||||||||||
| 6 | 4 | ELMA | 21,00 | SONUÇ | |||||||||||||||||
| 7 | 5 | KİRAZ | 52,00 | ||||||||||||||||||
| 8 | 6 | ELMA | 57,00 | ||||||||||||||||||
| 9 | |||||||||||||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| F3:F5 | F3 | =UNIQUE(C3:C8) |
| H3:H5 | H3 | =SUMIFS(D3:D8,C3:C8,F3#) |
| J3:J5 | J3 | =UNIQUE(C3:C8) |
| N3:N5 | N3 | =UNIQUE(C3:C8) |
| R3:T5 | R3 | =LET(X,WRAPROWS(TOCOL(C3:D8,1),2),Y,INDEX(X,,1),Z,UNIQUE(Y),HSTACK(Z,EXPAND("",COUNTA(Z),,""),BYROW(Z,LAMBDA(a,SUM((X=a)*INDEX(X,,2)))))) |
| L3:L5 | L3 | =SUMIFS(D3:D8,C3:C8,J3) |
| P3:P5 | P3 | =SUMIFS(D3:D8,urunler,N3) |
| Dynamic array formulas. | ||
| Named Ranges | ||
|---|---|---|
| Name | Refers To | Cells |
| urunler | =Sayfa1!$C$3:$C$8 | R3, N3, L3, J3, H3, F3, P3:P5 |
| Cells with Conditional Formatting | ||||
|---|---|---|---|---|
| Cell | Condition | Cell Format | Stop If True | |
| L3:L400 | Cell Value | >0 | text | NO |
| T3:T400 | Expression | =T3<>"" | text | NO |
| R3:R400 | Expression | =R3<>"" | text | NO |
| P3:P400 | Expression | =P3<>"" | text | NO |
| N3:N400 | Expression | =N3<>"" | text | NO |
| L3:L400 | Expression | =L3<>"" | text | NO |
| J3:J400 | Expression | =J3<>"" | text | NO |
| H3:H5,H7:H400 | Expression | =H3<>"" | text | NO |
| F3:F400 | Expression | =F3<>"" | text | NO |
| Cells with Data Validation | ||
|---|---|---|
| Cell | Allow | Criteria |
| C3 | List | =urunler |
| C4:C8 | List | ELMA;ARMUT;KİRAZ |
